count months between years

[dqm]

Hi -I need to calculate the months between years.
Eg. Start month Sept 08, end month April 2015.

Thanks in anticipation.

Naeem

 

[Harimau]

Use the DATEDIF function.

It doesn't have a helpfile in excel, but a good page for it here:
http://www.cpearson.com/excel/datedif.htm

 

[Mike H]

Try this with the earlier date in a1

=DATEDIF(A1,A2,"m")

Mike

 

[David Biddulph]

http://www.cpearson.com/excel/datedif.aspx