Age using date formula.

[Richard - St John Ambulance UK]

If I use the following formula to calculate members ages
in years it seems to round up after about 6 months and 20
days. e.g. someone who is 16years 21 days old is
displayed as 17. Can one of you clever people help?

=YEAR(N1)-YEAR(F52) (Year (N1) is taken from the current
date, TODAY().)

Thanks in advance!

Richard

 

[Dave R.]

Preferred method is referenced here;

http://tinyurl.com/6egfd

 

[Paul B]

Richard, have a look at Chip's site here
http://www.cpearson.com/excel/datedif.htm

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **

 

[Peo Sjoblom]

Try

=DATEDIF(DOB,TODAY(),"y")&" Years, "&DATEDIF(DOB,TODAY(),"ym")&" months and
"&DATEDIF(DOB,TODAY(),"md")&" days old"

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Richard]

Peo, thank you very much for your reply.

-----Original Message-----
Try

=DATEDIF(DOB,TODAY(),"y")&" Years, "&DATEDIF(DOB,TODAY (),"ym")&" months and
"&DATEDIF(DOB,TODAY(),"md")&" days old"

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)


"Richard - St John Ambulance UK"

 

[Myrna Larson]

Your formula calculates the age the person will be on their birthday in the
current year, not their age as of today. To do the latter, try this formula:

=DATEDIF(F52,N1,"y")