Help Calculating Partial Months between 2 dates.

Hi there. I am trying to obtain the number of months (to 2 decimal
places) between two dates:
w4 is 4/4/09
x4 is 6/30/09

Any ideas? Searched extensively but have not come up with a
solution. Client needs to show exact number of months to 2 decimal
places...

Thanks!!

show exact number of months to 2 decimal places...
w4 is 4/4/09
x4 is 6/30/09

What result do you expect based on your sample?

The problem with this is that a month is not a standard unit of measure. A
month can have 28,29,30 or 31 days.


--
Biff
Microsoft Excel MVP


"sirscottyog" wrote in message
...
Hi there. I am trying to obtain the number of months (to 2 decimal
places) between two dates:
w4 is 4/4/09
x4 is 6/30/09

Any ideas? Searched extensively but have not come up with a
solution. Client needs to show exact number of months to 2 decimal
places...

Thanks!!

Hi,

To get the completed months, use =DATEDIF(C4,C5,"m") where C4 is the
beginning date and C5 is the ending date. To get the balance months, use
=DATEDIF(C4,C5,"md")

Hope this helps.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"sirscottyog" wrote in message
...
Hi there. I am trying to obtain the number of months (to 2 decimal
places) between two dates:
w4 is 4/4/09
x4 is 6/30/09

Any ideas? Searched extensively but have not come up with a
solution. Client needs to show exact number of months to 2 decimal
places...

Thanks!!