How to calculate an age?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

PattiJ621 - 15 Mar 2006 16:42 GMT

I need to calculate ages as of 8/1/06. How can I do this if I enter the
Birthdates for each participant?

Reply to this Message

SteveG - 15 Mar 2006 16:49 GMT

Chip Pearson's site has exactly what you need.

HTH

Steve

http://www.cpearson.com/excel/datedif.htm

Signature

SteveG

Reply to this Message

Tom Ogilvy - 15 Mar 2006 16:59 GMT

see Chip Pearson's site for documentation on Datedif

http://www.cpearson.com/excel/datedif.htm

Signature

Regards,
Tom Ogilvy

> I need to calculate ages as of 8/1/06. How can I do this if I enter the
> Birthdates for each participant?

Reply to this Message

PattiJ621 - 15 Mar 2006 17:01 GMT

I tried that ... can somebody explain it simpler?

> see Chip Pearson's site for documentation on Datedif
>
> http://www.cpearson.com/excel/datedif.htm
>
> > I need to calculate ages as of 8/1/06. How can I do this if I enter the
> > Birthdates for each participant?

Reply to this Message

Paul B - 15 Mar 2006 17:46 GMT

PattiJ621, See if this will do what you want, put this in a cell and put
your birthday in A1

=DATEDIF(A1,DATE(2006,8,1),"y") & " years, " &
DATEDIF(A1,DATE(2006,8,1),"ym") & " months, " &
DATEDIF(A1,DATE(2006,8,1),"md") & " days"

Signature

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 2002 & 2003

>I need to calculate ages as of 8/1/06. How can I do this if I enter the
> Birthdates for each participant?

Reply to this Message