ChronologicalAge

Chronological Age Calculator / Calculators

Excel and Google Sheets Age Formulas

Enter the cells that hold the birth date and the test date.

Spreadsheet

Your result

Enter the values and press the button. The result appears here.

The DATEDIF units

UnitReturns
"Y"Complete years
"M"Complete months
"D"Days
"YM"Months after the complete years
"MD"Days after the complete months
"YD"Days after the complete years

Caution

Microsoft's documentation warns that the "MD" unit can return a negative number or an inaccurate result in some cases. For test scoring, check a few rows against this site's chronological age calculator. DATEDIF is not listed in Excel's function wizard, but it works when typed.

Example sheet

CellContentShows
A24/28/2018Date of birth
B25/20/2026Test date
C2=DATEDIF(A2,B2,"Y")8
D2=DATEDIF(A2,B2,"YM")0
E2=DATEDIF(A2,B2,"MD")22

The result 8;0;22 matches the hand calculation and this site's calculator.

Decimal years

For age in decimal years use =YEARFRAC(A2,B2,1), where basis 1 counts actual days. Different basis settings give slightly different decimals.

Dates stored as text

If a formula returns #VALUE!, the dates may be stored as text. Convert them with DATEVALUE or by re-entering them in a date format your spreadsheet recognizes.

Common questions

Does DATEDIF work in Google Sheets?

Yes, with the same units.

Sources

  1. Microsoft Support. DATEDIF function (Excel).

For information only. Always follow the rules in your test manual, your clinician's advice and your school district's official enrollment dates. Last reviewed November 2026.