Calculating Months while taking into consideration days
 

If I use the suggested formula
"=(YEAR(A4)-YEAR(A3))*12+MONTH(A4)-MONTH(A3)"
It will indeed calculate the number of months inbetween two dates, however.

If the date is in question is 2/9/05 and todays current date is 2/8/08
the answer will display as 36 months. That in fact, is incorrect. I want
it to take days into consideration. The correct answer should be 35 months,
and on the 9th of 2008 it will infact be 36 months. How do I make the proper
adjustments???

Calculating Months while taking into consideration days
 

On Fri, 8 Feb 2008 09:45:03 -0800, Excel Trouble
wrote:

If I use the suggested formula
"=(YEAR(A4)-YEAR(A3))*12+MONTH(A4)-MONTH(A3)"
It will indeed calculate the number of months inbetween two dates, however.

If the date is in question is 2/9/05 and todays current date is 2/8/08
the answer will display as 36 months. That in fact, is incorrect. I want
it to take days into consideration. The correct answer should be 35 months,
and on the 9th of 2008 it will infact be 36 months. How do I make the proper
adjustments???

Try

=DATEDIF(A1,A2,"m")


--ron

Calculating Months while taking into consideration days
 

Look he

http://www.cpearson.com/excel/datedif.aspx

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Excel Trouble" wrote in message
...
| If I use the suggested formula
| "=(YEAR(A4)-YEAR(A3))*12+MONTH(A4)-MONTH(A3)"
| It will indeed calculate the number of months inbetween two dates, however.
|
| If the date is in question is 2/9/05 and todays current date is 2/8/08
| the answer will display as 36 months. That in fact, is incorrect. I want
| it to take days into consideration. The correct answer should be 35 months,
| and on the 9th of 2008 it will infact be 36 months. How do I make the proper
| adjustments???

Calculating Months while taking into consideration days
 

With A1 and A2 having:

2/9/2005
2/8/2008

=DATEDIF(A1,A2,"m")
returns 35
--
Gary''s Student - gsnu200768


"Excel Trouble" wrote:

If I use the suggested formula
"=(YEAR(A4)-YEAR(A3))*12+MONTH(A4)-MONTH(A3)"
It will indeed calculate the number of months inbetween two dates, however.

If the date is in question is 2/9/05 and todays current date is 2/8/08
the answer will display as 36 months. That in fact, is incorrect. I want
it to take days into consideration. The correct answer should be 35 months,
and on the 9th of 2008 it will infact be 36 months. How do I make the proper
adjustments???