Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop text from stringing into next field when empty | Excel Worksheet Functions | |||
Stop text from stringing into next field when empty | Excel Worksheet Functions | |||
save text field w/ leading zeros in .csv format & not lose zeros? | Excel Discussion (Misc queries) | |||
How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) | |||
How do link to a remote field but use the path from a stored field | Excel Discussion (Misc queries) |