Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
what's the best way to calculate a person's years of age in excel
what's the best way to calculate a person's years of age in excel
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
what's the best way to calculate a person's years of age in excel
Try this:
A1 = date of birth =DATEDIF(A1,TODAY(),"y") Biff "Mein" wrote in message ... what's the best way to calculate a person's years of age in excel |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
what's the best way to calculate a person's years of age in excel
http://www.cpearson.com/excel/datedif.htm
-- Kind regards, Niek Otten Microsoft MVP - Excel "Mein" wrote in message ... | what's the best way to calculate a person's years of age in excel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to calculate person's age from DOB and current date? | Excel Discussion (Misc queries) | |||
excel how do I calculate income indexed each year for 15 years | Excel Discussion (Misc queries) | |||
calculate years worked by 3% * salary in excel | Excel Worksheet Functions | |||
How to calculate a person's age taking into account their birthda. | Excel Worksheet Functions | |||
Calculate months and years | Excel Discussion (Misc queries) |