Excel is a powerful spreadsheet tool that offers a wide range of features for calculation, analysis, and visualization of data. One of the frequently performed tasks on Excel is to calculate the age of a person or an object from a given date of birth. In this article, we will discuss how to calculate age in Excel from a specific date.
1. Use The YEARFRAC Function To Calculate Age From Birthdate.
- The most common method to calculate age in Excel is to subtract the birthdate of a person from the current date.
- Below are the steps to implement this.
- In an empty cell such as A1, enter the current date using the =TODAY() function.
- In another cell such as B1, enter the birthdate of the person using the DATE(year, month, day) function.
- For example, the birthdate could be entered as =DATE(1990,5,15) if the person was born on May 15, 1990.
- To calculate age in years, subtract the birthdate from the current date using the YEARFRAC(start_date, end_date) function, the YEARFRAC function returns the fraction of a year between two dates.
- For example, if the current date is March 1, 2021 and the birthdate is May 15, 1990, the formula in the cell would look like: =YEARFRAC(DATE(1990,5,15),TODAY()).
- In this example, we can input the formula =YEARFRAC(A1,B1) in cell C1.
- Multiply the result with 365.25 to get the exact age in days.
- For example, if the age in years is returned as 30.77, then the age in days can be calculated as 30.77*365.25= 11233.48.
2. Use The YEAR Function To Calculate Age From Birthdate.
- You can also use the YEAR function to calculate age from some one’s birthday.
- The YEAR function will return the year value of the provided date value.
- In this example, you should input the formula like =YEAR(TODAY())-YEAR(DATE(1990,5,15)) in a cell, and it will return the delta value of the year between today and the specified date.
3. Use The DATEIF Function To Calculate Year, Month or Hour From Birthday.
- To calculate age in months or even hours, modify the formula to use the DATEDIF(start_date, end_date, unit) function.
- This function allows you to calculate the difference between two dates in months, days, or years.
- For example, =DATEDIF(DATE(1990,5,15),TODAY(),”m”) would return the number of months between the birthdate and current date.
- Calculating age ( delta years, months, days, or hours between 2 given dates ) in Excel from a specific date can be done in a few simple steps using the YEARFRAC, YEAR, and DATEDIF functions.
- Knowing how to calculate age in Excel can be useful in various situations, such as calculating the age of customers, employees, students, or tracking the age of equipment or assets.
- By following the steps outlined in this article, you can easily calculate age in Excel and save time on manual calculations.