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

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

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

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

"Tim" wrote in message
...
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

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

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

On Sat, 17 Dec 2005 15:21:01 -0800, Tim wrote:

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