Subtracting 2 dates

[minnie]

I am trying to subtract two dates and even when the two cells are blank, I get .01 in the third cell where the result should go.

When I put in actual dates, the .01 gets added as an extra month.

For example:
Cell D22: 12/6/1994
Cell D23: 8/9/2002
Cell D24: 7.09

Cell D24 is a custom formatted cell as yy.mm

Any help on this is most appreciated.

 

[Yogi Anand]

Hi Mark:
Yours is more compact and elegant -- I had just wandered into this thread and suggested the modification that would be needed with the use of YearFrac function.

Your posts are always so insightful -- a MASTERPIECE!

Regards