How to calculate person's age in Excel

There are many ways to calculate a person's age in Excel.

To calculate the age of a person on date since their birthdate:
=INT((date-birthdate)/365.25)
To figure their age as of today, date can be replaced with a function like TODAY() or NOW(). The INT() function is used to return only the number of complete years.

Let's say suppose Cell A1 contains "13-11-1984", then you can find person's age by enterring the following formula as
=INT((A1-birthdate)/365.25)

To calculate age in terms of years, months, and days, DATEDIF is a handy function. The following formula is similar to the one above.
=DATEDIF(A1,TODAY(),"Y") & " years, " & DATEDIF(A1,TODAY(),"YM") & " months, " & DATEDIF(A1,TODAY(),"MD") & " days"

10 comments :

  1. Well we are an IT organization i.e. Computine LTD reputed IT organization in London providing outstanding IT and web based services in all over the world. We are known as a best London IT service providers. We offers Cisco network services, application development services London, Mobile Development services , Network support services London and much more. If you need more details just log on to in www.computine.co.uk

    ReplyDelete
  2. Nice post. We appreciate that. Given that ASP.NET is interested in many years, there are numerous developers that are expert at utilizing it to develop the best of apps. Establishing an application in Dot net training in Chennai with the assistance of this systems fairly cost-effective. The easy energy for this will allow the creators to perform the granted occupation inside the stipulated time period. And this also permits supply of quality products and services in dot net platform.Take a look to my blog Dot Net Training Academy in Chennai

    ReplyDelete
  3. Thanks for sharing this valuable information to our vision. You have posted a trust worthy blog keep sharing.
    Regards,
    Angularjs training in chennai|Angularjs training chennai

    ReplyDelete
  4. Your post on excel advanced training is really useful. I agree with your thoughts, knowledge on excel is mandatory for everyone. Excel Training in Chennai | Advanced Excel Training in Chennai

    ReplyDelete
  5. We share this advance excel related post is really excellent. I agree that our concepts for this post, I've learned from new knowledge excel related.Thanks you so much.
    Selenium Training in Chennai
    Selenium Course in Chennai

    ReplyDelete
  6. Thanks for your informative article. Softlogic Helo you to get the EXCEL TRAINING WITH PLACMENT IN CHENNAI. More Details Visit the Link

    ReplyDelete
  7. The purpose of the Excel application is to allow users to collect like data in a specific location for current and/or future use. custom excel dashboards

    ReplyDelete

> Related Posts with Thumbnails
 

Copyright © 2012. GS dot net - All Rights Reserved - Design by BTDesigner - Proudly powered by Blogger