Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to calculate age in years, months, and days in Excel and Google Sheets
Excel & Google Sheets
=DATEDIF(A2,TODAY(),"Y")&" yrs "&DATEDIF(A2,TODAY(),"YM")&" mo "&DATEDIF(A2,TODAY(),"MD")&" days"Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
Step by step
- 1Enter the birthdate in column A (A2).
- 2In B2 enter: =DATEDIF(A2,TODAY(),"Y")&" yrs "&DATEDIF(A2,TODAY(),"YM")&" mo "&DATEDIF(A2,TODAY(),"MD")&" days"
- 3"Y" returns complete years, "YM" returns remaining months after full years, "MD" returns remaining days after full months.
- 4Copy down for additional rows.
Tips
- To get just the age in whole years (e.g., for an Age column), simply use =DATEDIF(A2,TODAY(),"Y").
Need it for your exact data?
Describe your columns in plain English and get the precise formula for your sheet, with the right Excel or Sheets syntax.
Frequently asked
Why doesn't DATEDIF appear in Excel's formula suggestions?
DATEDIF is a legacy Lotus 1-2-3 function kept for compatibility. It works fine but is not listed in the autocomplete. Type it manually.
Can I use a fixed end date instead of TODAY()?
Yes — replace TODAY() with a cell reference or a date like DATE(2024,12,31) to calculate age at a specific point in time.