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.