I am trying to subtract one date from another and have the answer display as
yy/mm/dd. For example: If I subtract 2/18/1985 from 8/1/2006, the answer
should be 21/5/13 (21 years, 5 months, 13 days). For some reason, when I put
in the formula, it returns the answer 21/6/12 (21 years, 6 months, 12 days).
The formula I am putting in is +A1-B1 where A1=8/1/2006 and B1=2/18/1985. I
formatted the cell with the answer to a custom format of yy/mm/dd. I would
appreciate any suggestions.