How to Calculate Age in Excel

Greetings from your friendly CMO who happens to be an Excel wizard too! I know how frustrating it can be to figure out simple calculations in Excel, especially when it comes to calculating something as basic as age.

It's not as difficult as it seems, though. In fact, with just a few steps, you can calculate anyone's age in Excel.

Before we get into the details, let's make sure we're on the same page. For this tutorial, I’m assuming you have some basic knowledge of Excel and its formulas. If not, don't worry, I'll walk you through it step by step.

Step 1: Enter the Birthdate

The first step is the easiest – enter the birth date in the cell where you want the age to appear. Make sure the date is entered in the correct format – dd/mm/yyyy or mm/dd/yyyy.

Here's an example:

Birthdate: 01/01/1990

Step 2: Calculate the Age Using DATEDIF Function

Now that we have the birthdate, we need to calculate the age. For this, we will use the DATEDIF function in Excel. The syntax for the function is:

DATEDIF(start_date, end_date, unit)

Here, the start_date is the birthdate, end_date is today's date (we'll automatically get that using the TODAY function), and the unit is "Y" for calculating age in years.

It will look something like this:


Make sure you change "A2" to the cell that has the birthdate.

Step 3: Test Your Formula

The next step is to test your formula. Once you have entered the formula, press enter and you should see the age displayed.

Congratulations! You have successfully calculated someone's age in Excel!

Step 4: Format the Age

You might want to format the age to make it look better. Here's how:

  1. Select the cell with the age
  2. Right click and click on ‘Format Cells’
  3. In the ‘Format Cells’ dialog box, select the ‘Number’ tab
  4. From the list on the left, select ‘Custom’
  5. In the ‘Type’ field, enter the following code: 0 "years old"
  6. Click ‘OK’

The age will now be displayed like this:

30 years old


And there you have it – a simple way to calculate someone's age in Excel!

Excel is a powerful tool, and once you know how to use it, you'll find that it can help you do many tasks quickly and easily.

If you have any questions or comments, please feel free to leave them in the comments section below. I'd be happy to help!

By clicking “Accept”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. View our Privacy Policy for more information.