Slick SEO Tools

Age Calculator Excel - Calculate Age Of A Person Using Excel Formula

Calculate Age Of A Person Using Excel Formula

There may be multiple scenarios where you might need to calculate the age of a person or even complex a group of person based on their date of birth and upto a specific date.

Calculating the age of person in this scenario can be a real daunting thing to do.

You might find a way to calculate the age of a person using the online age calculator tools but there may be a scenario that you might have to calculate the age of 10's or 100's of people.

A good solution to this could be using an excel age calculator like we have over here.

Using excel you could easily enter the date of birth in one of the excel cells and then use our formula to calculate the age of these persons.

So let's see how to implement this Age calculator formula in excel.

How to calculate age using excel formula?

Calculating the age of a person or a group of persons using excel is really easy.

The latest versions of excel or even google sheets excel gives us this functionality to calculate the difference between 2 dates out of the box and it also gives us way to represent it nicely.

Let's see this in action.

In my example, I am using Google Sheets, but you may use Microsoft Excel and the results would be similar.

Excel and Google Sheets uses the DATEDIF function to calculate the difference between two given dates, and also is able to present it in Years, Months and Days.

This is really handy and useful to calculate age.

In the below example, we use the date of birth as '27-October-1983' and we will calculate the age of this person as of '16-October-2021'

Then the formula to calculate the Age would look like this (Showing the difference in dates in years):

=DATEDIF(A2,B2,"Y")&" Years "&DATEDIF(A2,B2,"YM")&" Months "&DATEDIF(A2,B2,"MD")&" Days"

Age Calculator Excel Formula

Breaking down the Age Calculator Excel Function (DATEDIF)

To calculate age of a person using excel or google sheets, we use the DATEDIF function.

The arguements of this function are as follows, it takes two dates as the first two parameters that you want the difference of, and as a third parameter, it takes a character string arguement for display purposes.

Display Date Difference in Years

=DATEDIF(A2,B2,"Y")&" Years"

Age Calculator Excel Formula



Display Date Difference in Months

=DATEDIF(A2,B2,"M")&" Months"

Age Calculator Excel Formula



Display Date Difference in Days

=DATEDIF(A2,B2,"D")&" Days"

Age Calculator Excel Formula



Understanding the Unit Arguement

  • "Y": the number of whole years between start_date and end_date
  • "M": the number of whole months between start_date and end_date
  • "D": the number of days between start_date and end_date
  • "MD": the number of days between start_date and end_date after subtracting whole months
  • "YM": the number of whole months between start_date and end_date after subtracting whole years
  • "YD": the number of days between start_date and end_date, assuming start_date and end_date were no more than one year apart