How to Calculate Age from Birthdate in Excel
Finding a person's age from their birthdate can be easily done using the TODAY() function in Excel. This guide will show you how.
Formula Genius can generate a draft from a plain-English prompt. Supported formulas can be checked with sample cases; review the coverage on the result.
The formula
"Calculate a person's current age in complete years from their date of birth using TODAY()"
=DATEDIF(A1, TODAY(), "Y")This formula calculates the number of complete years between a person's birthdate and today's date.
Step-by-step breakdown
- Step 1: Enter the birthdate in a cell, e.g., A1.
- Step 2: Use the TODAY() function to get the current date.
- Step 3: Apply the DATEDIF function to calculate the difference in years.
- Step 4: Use the "Y" argument to specify that you want the difference in complete years.
Edge cases & warnings
- The birthdate is in the future.
- The birthdate is today, resulting in an age of 0.
- Leap year birthdates may cause confusion in age calculation.
- Invalid date formats can lead to errors in the formula.
Examples
"Birthdate: 1990-05-15"
Age: 33"Birthdate: 2000-01-01"
Age: 23Frequently asked questions
How does the DATEDIF function work?
The DATEDIF function calculates the difference between two dates based on the specified unit.
What if the birthdate is today?
If the birthdate is today, the formula will return 0 as the age.
Can I use this formula for future dates?
No, the formula will not work correctly for future birthdates.
Can't find what you need?
Describe a formula in plain English. Formula Genius drafts and explains it, and can check supported formulas on sample cases.