Microsoft Office Forums Add ages in Excel

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-24-2015, 01:16 AM
Sohel_2015 Sohel_2015 is offline Add ages in Excel Windows 7 32bit Add ages in Excel Office 2007
Novice
Add ages in Excel
 
Join Date: Feb 2015
Posts: 1
Sohel_2015 is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 02-24-2015, 07:46 AM
gebobs gebobs is offline Add ages in Excel Windows 7 64bit Add ages in Excel Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 832
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

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
Reply With Quote
  #3  
Old 02-24-2015, 09:36 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Add ages in Excel Windows 7 64bit Add ages in Excel Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,397
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

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?
__________________
Please note I am not active on this forum anymore
Reply With Quote
  #4  
Old 02-24-2015, 11:14 AM
gebobs gebobs is offline Add ages in Excel Windows 7 64bit Add ages in Excel Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 832
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Quote:
Originally Posted by Pecoflyer View Post
Personally I would use TODAY() instead of NOW() as the second one also gives the time which, in this case, would not be necessary.
But NOW is shorter than TODAY. ;-)
Reply With Quote
  #5  
Old 02-25-2015, 09:42 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Add ages in Excel Windows 7 64bit Add ages in Excel Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,397
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

OTOH it returns a longer value
__________________
Please note I am not active on this forum anymore
Reply With Quote
  #6  
Old 02-25-2015, 12:21 PM
gebobs gebobs is offline Add ages in Excel Windows 7 64bit Add ages in Excel Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 832
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Not at midnight. :-)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Add ages in Excel How To Open an Macro From 2003 Excel in 2013 Excel Spread Sheet? ADubin Excel Programming 3 02-08-2015 04:57 AM
Add ages in Excel [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
Add ages in Excel 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


All times are GMT -7. The time now is 05:42 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft