Go Back   TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



How to calculate ages in Microsoft Excel

MS Office Support


Reply
 
Thread Tools Search this Thread
  #1  
Old 17-02-2012
Member
 
Join Date: Jan 2012
Posts: 55
How to calculate ages in Microsoft Excel

I need to create a formula to calculate age as of 04-30-10. Can anyone help me. I am using Excel 2007. Are there any default formula for the same. I got a template for that, but that is not so functional.

Reply With Quote
  #2  
Old 17-02-2012
Member
 
Join Date: Aug 2011
Posts: 575
Re: How to calculate ages in Microsoft Excel

You can use the following formula for the same. Type =DATEDIF(A1,B1,"y") with variable date in A1 and today's date in B1. There are other templates also that you can try out. Look in office help for the same.
Reply With Quote
  #3  
Old 17-02-2012
Member
 
Join Date: Aug 2011
Posts: 557
Re: How to calculate ages in Microsoft Excel

You can use the <today's date> function for the same. Make that your "certain date". If the birth date is in A1, you can write: = INT ((TODAY ()-A1) / 365). The person will turn 29 until the eve of his birthday or = ROUND ((TODAY ()-A1) / 365; 0). The person turns 30 soon as it is closer to 30 than 29. With the birth date in A1 and the formula = TODAY () in A2, you will age in A3 with the formula = YEAR (A2)-YEAR (A1) with Standard.
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to calculate ages in Microsoft Excel"
Thread Thread Starter Forum Replies Last Post
Need help to calculate Trend Growth in Microsoft Excel New!life MS Office Support 2 21-02-2012 01:22 PM
How to calculate overtime in Microsoft Excel Purujeet MS Office Support 2 15-02-2012 07:11 PM
How to calculate chronological age in Microsoft Excel Mr.Pandhre MS Office Support 4 27-01-2012 06:18 PM
What is the way to calculate standard error in Microsoft Excel Edha MS Office Support 4 24-01-2012 04:06 PM
How to calculate Autocorrelation in Microsoft Excel connoisseur MS Office Support 4 18-01-2012 04:43 PM


All times are GMT +5.5. The time now is 09:53 AM.