# How to Calculate Age from a Birthdate in Excel 2013

Excel has a lot of tools that can help you calculate values based on data that you’ve entered. You’ve probably had to add up values in Excel before, or maybe even calculate an average, but there is even more that you can do with numerical values that you have entered into a spreadsheet.

One other thing that you can do is calculate someone’s age based on a birthdate that’s been entered into a cell. Our tutorial below will show you the formula that lets you take a birthdate and compare it to the current date to see how old someone is.

## Quick Summary – How to Determine an Age from a Birthdate in Excel 2013

1. Open Excel 2013.
2. Type a birthdate into a cell in the format MM/DD/YYYY (if in the United States) or in the format DD/MM/YYYY if your country uses that format.
3. Type =DATEDIF(XX, TODAY(), “Y”) then press Enter on your keyboard. Change the “XX” part of the formula to the cell containing the birthdate.

For more information, including pictures, continue reading below for our expanded how-to guide on calculating age in Excel.

## Expanded – How to Calculate Age in Excel 2013

The steps in this article were performed using Microsoft Excel 2013, but will also work in most other versions of Excel. We will be using a formula, like this subtraction formula in Excel, to accomplish this.

This guide is focused specifically on calculating the age in years based on the entered birthdate, but we will include some modifiers for the formula at the end of the article if you want to calculate age in days or months, or if you want to display the age in years, months, and days.

Step 1: Open Excel 2013.

Step 2: Enter a birthdate into a cell using the format MM/DD/YYYY (United States) or DD/MM/YYYY if your country uses that date format instead.

Step 3: Type =DATEDIF(XX, Today(), “Y”) into the cell where you want to display the age, then press Enter on your keyboard. Be sure to replace the “XX” in the formula with the cell location containing the birthdate.