Skip to content

Calculate age from a date of birth

Get someone's age in whole years, as of today.

The formula

Argument separator
Excel and Google Sheets
=DATEDIF(A2, TODAY(), "Y")

How it works

  1. A2

    Date of birth.

  2. TODAY()

    Today's date, so the age updates automatically.

  3. "Y"

    Count complete years. Use "M" for months or "YM" for the months left over after the years.

Example

A: BornB: Result (on 2026-11-11)
1990-05-2036
2000-12-0125

Tips

  • DATEDIF works in Excel even though it is not listed in the function menu.