How to Calculate and Display Current Age from a Birthdate in Excel
In this article, we’ll show you how to automatically calculate and display the current age based on a birthdate in Excel. For example, if the birthdate "10/01/1990" is entered in a cell, you can display the corresponding age in the adjacent cell using the DATEDIF function.
How to Calculate Age Using the DATEDIF Function
The DATEDIF function calculates the difference between two dates in terms of years, months, or days. Here, we’ll use it to calculate the age by finding the difference between the birthdate and today’s date.
Steps
- Prepare a cell with the birthdate (e.g., A2).
- In the adjacent cell (e.g., B2), enter the following formula:
Example Formula
By entering the formula below in cell B2, you can calculate the age based on the birthdate in cell A2:
=DATEDIF(A2, TODAY(), "Y")
Formula Breakdown
- DATEDIF(start_date, end_date, unit): Calculates the difference between two dates.
- A2: The cell containing the birthdate.
- TODAY(): Returns today’s date, used as the end_date in the DATEDIF function.
- "Y": Specifies that the difference should be calculated in years, returning the current age.
Example
In the table below, column A contains birthdates, and column B displays the corresponding ages:
A | B | |
---|---|---|
1 | Birthdate | Age |
2 | 10/01/1990 | =DATEDIF(A2, TODAY(), "Y") |
3 | 15/05/1985 | =DATEDIF(A3, TODAY(), "Y") |
4 | 25/12/2000 | =DATEDIF(A4, TODAY(), "Y") |
Results
- Column B displays the calculated age based on the birthdates entered in column A.
- For example, if the birthdate is "10/01/1990", the result will be 33 years (as of 2023).
Conclusion
By using the DATEDIF function in Excel, you can easily calculate and display the current age based on a birthdate. This is a convenient feature for managing customer lists, staff directories, or any dataset requiring up-to-date age information.