Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculate age in years and month or decimal
I use =INT((TODAY()-D9)/365.25) to calculate the age of a person. No one is
under 8 years old so it works fine. The answer is given in years. I want the answer to be give as a decimal (i.e. 14.3). Another request is to have the answer years and months (16 years, 2 months) How can I get either or both of these done? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Displaying a decimal as years and months | Excel Worksheet Functions | |||
How do I subtract dates to get a number in years or years & month | Excel Discussion (Misc queries) | |||
Add decimal years to a date | Excel Worksheet Functions | |||
same month/day on x axis for multiple years | Charts and Charting in Excel | |||
Add one Month in the next cell for several months/years | Excel Discussion (Misc queries) |