software

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

www.cpearson.com/excel/datedif.htm--
SteveG
------------------------------------------------------------------------
SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=522667see Chip Pearson's site for documentation on Datedif

www.cpearson.com/excel/datedif.htm

--
Regards,
Tom Ogilvy
quot;PattiJ621quot; wrote:

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

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

quot;Tom Ogilvyquot; wrote:

gt; see Chip Pearson's site for documentation on Datedif
gt;
gt; www.cpearson.com/excel/datedif.htm
gt;
gt; --
gt; Regards,
gt; Tom Ogilvy
gt;
gt;
gt;
gt; quot;PattiJ621quot; wrote:
gt;
gt; gt; I need to calculate ages as of 8/1/06. How can I do this if I enter the
gt; gt; 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),quot;yquot;) amp; quot; years, quot; amp;
DATEDIF(A1,DATE(2006,8,1),quot;ymquot;) amp; quot; months, quot; amp;
DATEDIF(A1,DATE(2006,8,1),quot;mdquot;) amp; quot; daysquot;

--
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 amp; 2003

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