# Calculate Someone's Age in Excel

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

## 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.

- Type
**=YEAR(TODAY())-**into a cell. Note the minus sign after the last closing parenthesis. - Select the cell that contains the year the person was born.
- 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.

- Type
**=YEAR(TODAY())-**into a cell (just like in the first example). Make sure to include the minus sign after the last parenthesis. - Continue in the same cell typing
**YEAR(** - Select the cell that contains the date of the person's birth and then type a closing parenthesis.
- Hit Enter.
- 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). - 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.

## Question? Ask it in our Excel Forum

Tutorial: The Rate function in Excel (RATE) calculates the interest rate for a financial transaction...

Tutorial: How to force Excel to recalculate all formulas and functions without editing or entering ...

Tutorial: Use a function in Excel to get the number of the day in a week, from 1 to 7. This allows...

Tutorial: How to calculate the number of periods required for an investment in order to get the desi...

Tutorial: How to calculate the total number of working days between two dates in Excel. This allows...

Tutorial: The Present Value (PV) function in Excel will return the current value of an investment. ...