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
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