FormulaGenius
Date & Time

Calculate Age from Birthday

Calculate a person's current age in years from their date of birth. Handles leap years and varying month lengths correctly.

Excel Formula

=DATEDIF(A2, TODAY(), "Y")

Step-by-Step Explanation

1

DATEDIF calculates the difference between two dates

2

A2 is the birth date

3

TODAY() returns the current date

4

"Y" specifies to return whole years

5

Result is the person's age in complete years

Example

Birth Date (A)Age (B)
5/15/199035
11/3/196857
2/29/200026

Result: Formula in B2: =DATEDIF(A2,TODAY(),"Y") → 35

Common Variations

Age in years and months

=DATEDIF(A2,TODAY(),"Y")&" years, "&DATEDIF(A2,TODAY(),"YM")&" months"

Shows years and remaining months

Exact age in days

=TODAY()-A2

Total days lived

Age at specific date

=DATEDIF(A2,B2,"Y")

Age at a date other than today

Need a Custom Version?

Use our AI generator to create a formula tailored to your specific data and requirements.

Try It with AI →

Related Templates

Date & Time

Days Until a Date

Count days remaining until a future date

Date & Time

Business Days Between Dates (NETWORKDAYS)

Count working days between two dates excluding weekends and holidays

Date & Time

Convert Text to Date

Parse and convert text strings into proper dates