What Is the Formula to Calculate Age in Excel?


Quick Answer

The formula to calculate age in Excel is: =DATEDIF(CELLREF,TODAY(),"Y") & " Years, " & DATEDIF(CELLREF,TODAY(),"YM") & " Months, " & DATEDIF(CELLREF,TODAY(),"MD") & " Days". In this formula, replace "CELLREF" with the corresponding cells on the spreadsheet.

Continue Reading
Related Videos

Full Answer

In order to calculate age, the spreadsheet should house the current date, represented by the formula "TODAY()" without the quotation marks, and date of birth in separate cells. The third cell should contain the formula to calculate and display the age in years, months and days.

Excel is a spreadsheet application within the Microsoft Office suite. Spreadsheets provide flexibility and increased productivity for data analysis and general accounting tasks with the use of formulas and macros.

Learn more about Software

Related Questions