Johnny Andersson wrote:
... If I do something like 2007-03-05 - 2007-03-03 the answer should
be 2 (days), right? But if I enter 2007-03-05 in A1, 2007-03-03 in
B1and =A1-B1 in C1, and then format C1 as DD, C1 shows 01, not 02
which I think would be more appropriate.
Dates are represented as an integer number of days after some starting
date. If you subtract two such dates, you are simply subtracting two
integers, so the result is an integer number of days between the dates:
39146-39144 = 2. What is does the result "2" now represent?
So why is 0 days = 1899-12-30? ...
Why not?
Or just Document_date - Birth_date + 1, formatted as YY. ...
No, for the same reason that "2" formatted as "DD" gives you the wrong
answer.
Of course (back to the original question), if you're entering the birth
date and the document date by hand already, why not just enter the years
rather than the exact date. No more problem, just Doc_year - Birth year.
<Joe
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
