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