Excel : Find out age from birthdate

Let us say you want to determine the age from the entered birthdate then you can use the below formula to find out the age

=ROUND(DAYS360(C5,NOW())/365,0)

image

Functions Used :-

  • DAYS360 – Returns number of days between two dates based on a 360-day year.
  • NOW – Returns Current date and time
  • ROUND – Rounds a number to specified number of digits.

Step 1: Use DAYS360 function to determine the difference between the birthdate (C5) and Current date (NOW)

e.g. For birth day entered as “23/12/2007” (C5), the result for =(DAYS360(C5,NOW())) is 1978

Step 2: Divide the result from step 1 by 365.

Step 3: Round of the result of step 2 by number of digits set to 0.

You can avoid step 3, if you set cell formatting to Number with 0 decimal places. The Shortened formula would be with out ROUND i.e.. DAYS360(C5,NOW())/365

image

In Category: Excel 2013, Office 2013

Ravi Shankar

A Software developer and blogger who is always looking to provide technical help to the wider community.

Show 0 Comments
No comments yet. Be the first.

Leave a Comment

Get your free copies of the following tech guides by joining the Digital Answers mailing list.