Calculation of number of months

Closed
boatman3 - Jan 13, 2015 at 08:01 AM
 RayH - Jan 13, 2015 at 12:20 PM
Hello,

number of months between 1/7/2013 and 26/1/2015

1 reply

=(Date2-Date1)/(365.25/12)
or
=(YEAR(Date2)-YEAR(Date1))*12+MONTH(Date2)-MONTH(Date1)

http://support.microsoft.com/kb/214134
0