#1
|
|||
|
|||
Add ages in Excel
How add age in Excel. I have Some people age like 1.24 years, 5 Months, 24 days, 2. 20 years, 6 months, 28 Days, 3. 18 yeas, 6 Months, 12 Days, I want to this age added. How do it in excel? Help me |
#2
|
|||
|
|||
Add them like you add anything else. Dates are really just floating point numbers.
First, calculate the ages of each i.e. convert it to total days: 365*Years+30*Months+days This won't give exact numbers since not all years are 365 and not all months are 30 days. If you want, 365.25 for years and 30.4 for months. Better yet, you can calculate the number directly from their birth date: =now()-Birthdate For this, it's probably best that you enter the birth date in another cell and reference that cell in the formula e.g. if the birthdate is in A1: =now()-A1 Now just add 'em all up. If you want, you can format this number to display any number of ways e.g. yy,m,d |
#3
|
||||
|
||||
Personally I would use TODAY() instead of NOW() as the second one also gives the time which, in this case, would not be necessary. Also being volatile ( as is today() ) does not help.
But why would one want to add ages?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#4
|
|||
|
|||
But NOW is shorter than TODAY. ;-)
|
#5
|
||||
|
||||
OTOH it returns a longer value
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#6
|
|||
|
|||
Not at midnight. :-)
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How To Open an Macro From 2003 Excel in 2013 Excel Spread Sheet? | ADubin | Excel Programming | 3 | 02-08-2015 04:57 AM |
[Excel 2007] Building Power Point Slides from data in an Excel Table | bremen22 | Excel Programming | 1 | 08-07-2013 11:01 AM |
Paste special an Excel range into Outlook as an Excel Worksheet | charlesh3 | Excel Programming | 3 | 02-04-2013 04:33 PM |
Excel 2011 can't open old Excel 98 or Excel X files | FLJohnson | Excel | 8 | 05-09-2012 11:26 PM |
Excel 2007 custom ribbon not showing in Excel 2010 | Paulzak | Excel | 2 | 02-17-2012 06:35 PM |