| 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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Calculate age in years and month or decimal
http://www.cpearson.com/excel/datedif.aspx
-- Gary''s Student - gsnu2007j "HH" wrote: 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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Calculate age in years and month or decimal
Thanks,
Just what I needed. "Gary''s Student" wrote in message ... http://www.cpearson.com/excel/datedif.aspx -- Gary''s Student - gsnu2007j "HH" wrote: 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? |
| Reply |
| 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) | |||
![HH[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
