Counting Dates

B

billy

Hi,

I have two dates: 1/1/01 & 5/25/04
How can i write a formula that will show the number of months from 1/1/01
thru 5/25/04? This should show 53. I don't need days but months.

Thanks,
 
G

goober

A3=end date
A2=start date

=MONTH(A3)-MONTH(A2)
Months between two dates in the same year


=(YEAR(A3)-YEAR(A2))*12+MONTH(A3)-MONTH(A2)
Months between two dates over a year apart


Hope it helps
 
G

Govind

Hi,

You can try the formula =DATEDIF(Start date,end date,"m"). For eg, where
Start date is in cell A1 and end date in cell B1, use =DATEDIF(A1,B1,"m").

However, this formula would compute only completed months elapsed
between start date and end date.

Regards

Govind.
 
R

Ron Rosenfeld

Hi,

I have two dates: 1/1/01 & 5/25/04
How can i write a formula that will show the number of months from 1/1/01
thru 5/25/04? This should show 53. I don't need days but months.

Thanks,
Click to expand...

How can there be 53 months from 1 January 2001 to 25 May 2004 given that there
are only twelve months in a year???


--ron
 
B

billy

All.

Thanks for responding to my question with an answer. I actually meant 41
months instead of 53. I added an extra year. Sorry for the confusion. :(
 
R

Ron Rosenfeld

All.

Thanks for responding to my question with an answer. I actually meant 41
months instead of 53. I added an extra year. Sorry for the confusion. :(
Click to expand...

OK, but there are still issues in your specifications.

For example, in your dates, May is not a full month, so the number of full
months is actually 40 and not 41. How do you want to resolve this?

And on a related note, how do you want to resolve month counts if the start
date does not begin at the first day of the month?

e.g. How many months between 1/15/05 and 3/3/05?


--ron
 
Top