What is the formula to calculate age in Excel?

By Forinfos - 19/04/2025 - 0 comments

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.

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.

Login to Comment

Comments

Be the first to write a comment for this article.

Related Articles

What is the formula in Excel for calculating CAGR? How do you calculate the total hours formula in Excel? What is the formula to calculate average? What is the formula for calculating acreage? What is the formula to calculate exchange rates? What are some easy formulas to calculate percentages in Excel? What is the formula to calculate wind chill? What is the formula for calculating asphalt tonnage? What is the formula to calculate force? What is the formula to calculate BMI?

Trending Articles

How do you find a list of recommended books? Is Teresa Earnhardt remarried? How many songs has John Denver released? How do you draw a cross? Did John Denver get divorced? How long was Anne Frank in hiding? How many films has Helen Mirren starred in? How do you legally watch "Gold Rush" online? How many songs did Elvis Presley record? How do you upload a file to SoundCloud?