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

Tim · Dec 17, 2005

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

Paul B · Dec 17, 2005

Tim, have a look here for ways to do it

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

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

Gord Dibben · Dec 17, 2005

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