Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
How to calculate # of months between 2 dates...?
0 views
Skip to first unread message
Dan B
Oct 22, 2003, 5:38:32 PM10/22/03
to
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?
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
Oct 22, 2003, 5:49:26 PM10/22/03
to
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
"Dan B" <no...@none.com> wrote in message news:uPUSTUOm...@TK2MSFTNGP11.phx.gbl...
0 new messages