Counting months

[gary]

Date 1 = May 01 1975
Date 2 = July 25 2062

what formula counts the exact number of months between the
two?

Cheers.

 

[Chip Pearson]

Gary,

Use the DATEDIF function. E.g.,

=DATEDIF(A1,A2,"m")

See www.cpearson.com/excel/datedif.htm for more details.

 

[Mike]

A
1 May 01 1975
2 July 25 2062
3 1046

A3: =DATEDIF(A1,A2,"M")

Is 1046 months what you expected?
(87 years 2 months and 24 days)

 

[gary]

cheers

-----Original Message-----
Gary,

Use the DATEDIF function. E.g.,

=DATEDIF(A1,A2,"m")

See www.cpearson.com/excel/datedif.htm for more details.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com (e-mail address removed)






.