Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a list of names with birthdates and would like to calculate each ones
age in years, months, and days from the present day. I am using Excel 2003 SP2. I see how to use the Today function to get the present day. A subtraction yields the number of days from 1/1/1900. In date format I get a date earlier than the birthdate. I use the following formula: (Today - birthdate)/365 to yield decimal years. I am presently changing the format of the box to yield a number with decimal places. I would like to have the result show up as years, months, days, in other words, the age of the individual, not a date. Can anyone help me? Jerry Smith |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
How do I calculate the root of a number using Excel? | Excel Worksheet Functions | |||
how to calculate the hours and minutes in excel | Excel Discussion (Misc queries) | |||
how to calculate surface area in excel chart | Charts and Charting in Excel |