How to count the number of months between 2 periods?

[Eric]

Does anyone have any suggestions on how to count the number of months between
2 periods? such as
Assuming the the day for each period is 1 as a default.
In cell A1, the period is 1-Mar-08 and
In cell B1, the period is 1-Feb-08,
then it should return 1 in cell C1, because there is 1 month between 2
periods.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric

 

[Max]

In C1: =DATEDIF(B1,A1,"m")

 

[Pete_UK]

Why do people insist on counting months ?

Pete

In C1: =DATEDIF(B1,A1,"m")
--
Max
Singaporehttp://savefile.com/projects/236895
xdemechanik
---





- Show quoted text -

 

[Fred Smith]

It's important to lots of things in life. People get paid monthly, pay their
rent monthly, car leases, mortgage payments, etc. It's not their fault that
months are different lengths. They still want to know the number of months.

Regards,
Fred.

Why do people insist on counting months ?

Pete