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.

## 4. Conclusion.

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