Calculation of number of months

Closed
boatman3 - 13 Jan 2015 à 08:01
 RayH - 13 Jan 2015 à 12:20
Hello,

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

1 response

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

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