Q:

What is the formula to calculate age in Excel?

A:

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.

Keep Learning

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.

Sources:

Related Questions

• A: To enter a basic formula in Excel, enter an equal sign into the cell where you want to place the formula. This signals to Excel that the following input is... Full Answer >
Filed Under:
• A: To subtract dates in Excel, simply enter the following formula: "=A3-A2", assuming that cells A3 and A2 contain the dates that need to be subtracted. This ... Full Answer >
Filed Under:
• A: The formula for calculating compound annual growth rate (CAGR) in Excel is: = ((FV/PV)^(1/n)) – 1, where "FV" is the ending value, "PV" is the beginning va... Full Answer >
Filed Under:
• A: To divide by the sum of cells A1 through A10 by 2 in Excel, use the formula: =SUM(A1:A10)/2. It is also possible to enter numbers directly into the formula... Full Answer >
Filed Under:
PEOPLE SEARCH FOR