Question: how to calculate number of months between two dates in excel 2007?
Answer: =DATEDIF( start_date, end_date, “M”)
=DATEDIF(B2,C2,"M")
=(YEAR(end_date)-YEAR(start_date))*12+MONTH(end_date)-MONTH(start_date)
=(YEAR(C2)-YEAR(B2))*12+MONTH(C2)-MONTH(B2)
=YEARFRAC( start_date, end_date) * 12.