I need to calculate the interval between two dates in the SharePoint 2013 list calculated column. the reason is that, i will need to set a field value based on the interval, for example,
if "Current Month" - "Last Reviewed Month" < 6, then set the field value =" green", and if "Current Month" - "Last Reviewed Month" > 6 and = "", then set the field value to "red".
I'm at a loss how to calculate the month range between two dates, for example, how many months between today and April 2015.