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