How to count the number of months between 2 periods?
 

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

How to count the number of months between 2 periods?
 

In C1: =DATEDIF(B1,A1,"m")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Eric" wrote:
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

How to count the number of months between 2 periods?
 

Why do people insist on counting months ?

Pete

On Feb 5, 1:52*pm, Max wrote:
In C1: =DATEDIF(B1,A1,"m")
--
Max
Singaporehttp://savefile.com/projects/236895
xdemechanik
---



"Eric" wrote:
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- Hide quoted text -

- Show quoted text -

How to count the number of months between 2 periods?
 

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.

"Pete_UK" wrote in message
...
Why do people insist on counting months ?

Pete

On Feb 5, 1:52 pm, Max wrote:
In C1: =DATEDIF(B1,A1,"m")
--
Max
Singaporehttp://savefile.com/projects/236895
xdemechanik
---



"Eric" wrote:
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- Hide quoted text -

- Show quoted text -