We have the following dataset containing some workers’ names and dates of Birth (DOB). We will show some step-by-step methods to calculate their age in Excel in years and months. Method 1 – Using the Excel DATEDIF Function to Calculate Age in Years and Months Steps: Select cellD5. En...
=(YEAR(TODAY())-YEAR(B2)) This formula finds the age in the current date. If you want to use a specific date instead, you can use the cell reference for the date instead of the “TODAY” function. Wrapping Up Calculating age in Excel is a fundamental task that can be accomplished us...
Method 3 – Determine Average Age with Excel SUBTOTAL FunctionThe SUBTOTAL function also allows us to calculate the average age in Excel. Enter the following formula in cell D14 to do that.=SUBTOTAL(1,D5:D12)This formula allows you to filter your dataset. 1 indicates the AVERAGE function...
Since people usually give their age in completed years, you might want to know how to calculate just the years from a date in Excel. In this case, we can truncate the result to remove the decimal part and just leave the number of years. To calculate the age from the date of birth in...
Calculate age from date of birth with YEARFRAC function A more reliable way to convert DOB to age in Excel is using the YEARFRAC function that returns the fraction of the year, i.e. the number of whole days between two dates. The syntax of the YEARFRAC function is as follows: ...
The month of December 2019 has been excluded from the calculation as it is not a completed month. In this way, the number of completed months for the remaining rows has been calculated by Excel. b.The steps for calculating the age in excel (time gap) in fractional months are listed as ...
So, to calculate someone’s age in Excel, you would use a formula like this: =YEARFRAC(DATE(birth_year, birth_month, birth_day), TODAY()) How do you calculate age from birthdate in Excel? What is the formula to calculate the age? There is no one-size-fits-all answer to this ...
To display someone's age in years, months, and days at the same time, use theDATEDIFfunction with all the arguments combined. You can alsocombine text from multiple cells into one cellin Excel. We'll use the following spreadsheet for the calculation: ...
This tutorial covershow to calculate age in Excel. Calculate Exact Age To calculate the exact age of a person, you want to calculate the difference between the current date (or any other desired date) and the birth date. You might think that you could simply take the difference in days be...
=YEAR(NOW())-1960 The age of a person born in 1960, without using cell references. If this cell doesn't display as a number, ensure that it is formatted as a number orGeneral. Learn how toformat a cell as a number or date. ...