Knowing how to determine ages from birthdates is a common requirement in many fields, from HR to health care. In Excel, the DATEDIF function is a handy tool for calculating the difference between two dates, making it perfect for age calculation.
Determine ages from birthdates using the DATEDIF function
The DATEDIF function in Excel calculates the difference between two dates in years, months, or days. For age calculation, we'll focus on determining the difference in years.
Example
Below is an example table demonstrating how to calculate ages from birthdates using the DATEDIF function:
| Name | Birthdate | Age |
|---|---|---|
| John Doe | 1980-05-15 | =DATEDIF(B2, TODAY(), "Y") |
| Jane Smith | 1990-12-25 | 3=DATEDIF(B3, TODAY(), "Y") |
| Emily Johnson | 2005-07-19 | =DATEDIF(B4, TODAY(), "Y") |
Exercise
Now it's your turn to calculate ages. Use the provided Excel sheet to determine the ages of the following individuals based on their birthdates:
Solution
To solve the exercise, follow these steps:
- Enter the birthdate in the cell.
- Use the DATEDIF function to calculate the age.
Example Calculation:
- For "Alice Brown":
- Birthdate: 1985-03-10
- Formula for Age:
=DATEDIF(B2, TODAY(), "Y") - Result: 39
This table provides a clear layout for calculating ages using the DATEDIF function in Excel. Users can input their data and see the results immediately within the embedded sheet.