As Seen on TechCrunch: Finofo Raises $1.65M CAD!

Excel Guide

How to Calculate Age in Excel: Step-by-Step Guide

If you need to calculate someone's age in Excel, you can easily achieve this using a simple formula. Here's a step-by-step guide:

1. Open your Excel workbook.

2. Enter the date of birth in a cell.

For this example, let's assume the date of birth is in cell A1.

3. In the cell where you want to display the age, enter the following formula:


This formula subtracts the date of birth from the current date.

4. Press Enter.

The age will be displayed in the cell.

Formatting the Cell:

You can format the cell displaying the age for better readability. Follow these steps:

  • Select the cell.
  • Click the Number Format drop-down in the Number group on the Home tab.
  • Choose a format such as General or Number.

Adding Conditions:

If you want to add conditions based on age, such as displaying a different message for individuals under 18, you can use the IF function. Here's an example:

=IF(TODAY()-A1<18, "Under 18", "18 or over")

This formula checks if the calculated age is less than 18. If true, it displays "Under 18"; otherwise, it shows "18 or over". You can customize the messages based on your needs.


Calculating age in Excel is a simple process using the TODAY function and basic arithmetic. Feel free to customize the formula and formatting based on your specific requirements. If you have any questions or need further assistance, feel free to ask!