How can I create a field indicating a persons age by using bd inf

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tim - 17 Dec 2005 23:21 GMT

How can I create an age field in excel using birthday info and possibly the
"today' function. I would not care if the answer is decimal or days as long
as it makes sense. Thanks in advance. Tim

Reply to this Message

Paul B - 17 Dec 2005 23:27 GMT

Tim, have a look here for ways to do it

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

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

> How can I create an age field in excel using birthday info and possibly the
> "today' function. I would not care if the answer is decimal or days as long
> as it makes sense. Thanks in advance. Tim

Reply to this Message

Gord Dibben - 17 Dec 2005 23:43 GMT

Tim

The undocumented DATEDIF Function.........

Assuming birthdate in A6

=DATEDIF(A6,TODAY(),"y") & " years, " & DATEDIF(A6,TODAY(),"ym") & " months,
"& DATEDIF(A6,TODAY(),"md") & " days,"

OR is birthdate in A6 and later date in A7

=DATEDIF(A6,A7,"y") & " years, " & DATEDIF(A6,A7,"ym") & " months, "&
DATEDIF(A6,A7,"md") & " days,"

Gord Dibben Excel MVP

>How can I create an age field in excel using birthday info and possibly the
>"today' function. I would not care if the answer is decimal or days as long
>as it makes sense. Thanks in advance. Tim

Reply to this Message