How to Calculate Age in Excel & Google Sheets Using DATEDIF

Master the DATEDIF formula in Microsoft Excel and Google Sheets to compute exact years, months, and days.

Whether managing HR employee records or academic databases, calculating exact age in spreadsheets requires specific functions rather than simple subtraction.

The Master DATEDIF Formula

Assuming Date of Birth is in cell A2:

=DATEDIF(A2, TODAY(), "Y") & " Years, " & DATEDIF(A2, TODAY(), "YM") & " Months, " & DATEDIF(A2, TODAY(), "MD") & " Days"

Check your spreadsheet calculations against our live web tool at AgeCalculate.net.

Marcus Brody, Spreadsheet Specialist

Author & Calendar Research Contributor at AgeCalculate.net. Specializing in chronometry, astronomical synchronization, and algorithmic date validation.

Calculate Your Exact Age in Seconds

Get your precision years, months, days, and next birthday countdown.

Launch Calculator →

How to Calculate Age in Excel & Google Sheets Using DATEDIF

The Master DATEDIF Formula

Marcus Brody, Spreadsheet Specialist

Calculate Your Exact Age in Seconds

Related Articles & Guides

The Math Behind Leap Years & Feb 29

India vs USA Date Formats Guide