Help Calculating Partial Months between 2 dates.

[sirscottyog]

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!!

 

[T. Valko]

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.

 

[Ashish Mathur]

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