|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
Adding and subtracting dates
See this:
http://cpearson.com/excel/datedif.htm
Biff
"Bjair" wrote in message
...
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.
|