Hello, number of months between 1/7/2013 and 26/1/2015 Configuration: Mac OS X Lion (10.7.5) / Chrome 39.0.2171.95

Previous Topic Next Topic

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

Answer 1 / 1

RayH
Jan 13, 2015 at 12:20 PM

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

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