How to calculate # of months between 2 dates...?

[Dan B]

Hi,
I have two dates and need a formula to calculate how many month are between
them. I tried
=month(A1)-month(A2) but it didn't work. What's the right way to do that?

Thanks,
Dan

 

[Dan E]

Dan,

Have a look at the DATEDIF function, detailed in help (Excel 2000 only) and
at http://www.cpearson.com/excel/datedif.htm for all other versions...

=DATEDIF(A1,A2,"m") OR =DATEDIF(A1,A2,"ym")
depending on what your after

Dan E