Subtracting months from each other

[zivro]

I would like to know how I can subtract 2 dates from each other and as a
result get the difference in number of months.

 

[Mike H]

Hi,

With the earlier date in a1

=DATEDIF(A1,B1,"m")

Datedif isn't documented in excel, for help look here


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

Mike