Chronological Age Calculator / Calculators
Excel and Google Sheets Age Formulas
Enter the cells that hold the birth date and the test date.
Your result
Enter the values and press the button. The result appears here.
The DATEDIF units
| Unit | Returns |
|---|---|
| "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
| Cell | Content | Shows |
|---|---|---|
| A2 | 4/28/2018 | Date of birth |
| B2 | 5/20/2026 | Test 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.
Related pages
Sources
- 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.