Calculate age
Hi Susan
Just subtract the two dates and format the resulting cell as Custom "yy".
Hopes this helps.
---
Per
"Susan Sia" .(donotspam) skrev i meddelelsen
...
How can I calculate age accurately? If I put in the following two dates
and
use the "Callculate the number of years between two dates" function, I get
26
as the answer, whereas the actual age is 25.
13/09/2003
09/04/2009
--
Susan
|