Does anyone know how to calculate the number of months between two dates? Calculating the days is easy per my formula in the image below.
Solved! Go to Solution.
by utilizing the Functions MONTH() and YEAR() you can derive the number of months between 2 date formatted line items with this formula: IF ISBLANK(start date) THEN 0 ELSE IF ISBLANK(end date) THEN YEAR(START()) * 12 + MONTH(START()) - (YEAR(start date) * 12 + MONTH(start date)) ELSE YEAR(end date) * 12 + MONTH(end date) - (YEAR(start date) * 12 + MONTH(start date))