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