Thread: Calculate age
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Per Jessen Per Jessen is offline
external usenet poster
 
Posts: 1,533
Default 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