Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
caculate a persons age
What function do I use to caculate someones age
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
caculate a persons age
Hi
=DATEDIF(BirthDate,TODAY(),"y") to get the current age in years. =DATEDIF(BirthDate,TODAY(),"ym") to get months over full years. =DATEDIF(BirthDate,TODAY(),"y") to get days over full months. (there may be some inaccuracies due variable month lengths for last 2 formulas for specific dates as function 2 first parameters). -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) "Dave" wrote in message ... What function do I use to caculate someones age |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
caculate a persons age
See this:
http://cpearson.com/excel/datedif.htm Biff "Dave" wrote in message ... What function do I use to caculate someones age |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
what formula do i need to calculate a persons age | Excel Discussion (Misc queries) | |||
How can I caculate text in a column? | Excel Discussion (Misc queries) | |||
Function to caculate date | Excel Discussion (Misc queries) | |||
pivit table will not caculate | Excel Discussion (Misc queries) | |||
Caculate Age | Excel Worksheet Functions |