I want to be able to enter two dates and have the computer provide the number
of months and the number of years to two decimal places. It ought to be easy
but I cannot figure this out.

I have used the YEARFRAC formula and that sort of works...

Except if I put in two dates that are a year apart (July 1, 2004 and June
30, 2005 for example) I do not get 1 year or 12 months. I get fractions in
both instances. Same with July 1 and July 31. That is one month but I get a
fraction.

Even if excel did not recognize that July 1 and July 31 represents exactly 1
month and instead, I had to put August 1 in, I could live with this because I
could just modify the formula but even that does not work.

The Dateif command does not work as it only provides complete months/years
and I need fractions.

Any ideas would be greatly appreciated.


Ned.