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

Chip Pearson's site has exactly what you need.

HTH

Steve

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


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=522667

see Chip Pearson's site for documentation on Datedif

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

--
Regards,
Tom Ogilvy



"PattiJ621" wrote:

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

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

"Tom Ogilvy" wrote:

see Chip Pearson's site for documentation on Datedif

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

--
Regards,
Tom Ogilvy



"PattiJ621" wrote:

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

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"

--
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

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