Calculate Someone's Age in Excel

Add to Favorites

How to automatically calculate someone's age using Excel.  This method is simple and will update every year so that you never have to manually adjust an age in Excel.

This is great when you are working with employee or customer data.

I'll show you two methods to do this; which one you use depends on the setup of your data.

Sections:

Calculate Someone's Age When you Have the Year of Their Birth

Calculate Someone's Age When you Have the Date of their Birth

Notes

Calculate Someone's Age When you Have the Year of Their Birth

This method assumes that you have a plain number for the year that the person was born in its own cell.

  1. Type =YEAR(TODAY())- into a cell.  Note the minus sign after the last closing parenthesis.
  2. Select the cell that contains the year the person was born.
  3. Hit Enter and that's it.

Calculate Someone's Age When you Have the Date of their Birth

This method assumes that you have the actual date the person was born in a cell.  This is perhaps the more common way of keeping track of a person's information.

  1. Type =YEAR(TODAY())- into a cell (just like in the first example).  Make sure to include the minus sign after the last parenthesis.
  2. Continue in the same cell typing YEAR(

  3. Select the cell that contains the date of the person's birth and then type a closing parenthesis.
  4. Hit Enter.
  5. Excel might format the result as a date, like it did for me and, in that case, we need to format the cell as a regular number or just as General (Home tab > Number section > Select General from the drop-down menu).
  6. That's it!

Notes

This is a great technique for getting someone's age without much hassle.  Even though it looks complicated, we are just using the YEAR function to get the year from the TODAY function, which returns the current date, and, in the second example, using the YEAR function to get the year from the person's birth date.

Check out our other date and time tutorials for Excel.

Make sure to download the accompanying Excel file so you can follow along with this tutorial and get a better understanding of how this works.


Excel Function: TODAY(), YEAR()
Downloadable Files: Excel File

Similar Content on TeachExcel
RATE Function - Calculate an Interest Rate in Excel
Tutorial: The Rate function in Excel (RATE) calculates the interest rate for a financial transaction...
Manually Calculate Formulas and Functions in Excel
Tutorial: How to force Excel to recalculate all formulas and functions without editing or entering ...
Get the Day of the Week (1 to 7) for a Date in Excel - WEEKDAY
Tutorial: Use a function in Excel to get the number of the day in a week, from 1 to 7.  This allows...
NPER Function - Calculate Number of Periods Needed for a Set of Payments in Excel
Tutorial: How to calculate the number of periods required for an investment in order to get the desi...
Get the Number of Workdays Between Two Dates in Excel
Tutorial: How to calculate the total number of working days between two dates in Excel.  This allows...
Calculate the Difference Between Two Times in Excel
Tutorial: Here, youll learn how to get the difference between two times in Excel. A common example...