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