QUESTION
Is there a simple formula that can calculate the number of months between two given dates?
ANSWER
Assuming that the Expiration date is in Cell B1 and the date you want to calculate the difference from is in cell A1 then the formula would be:
=(YEAR(B1)-YEAR(A1))*12+(MONTH(B1)-MONTH(A1))
It multiplies the difference in years by 12 and adds the difference in months.
