How to Calculate Age from Date of Birth in Excel
![](https://www.thetechedvocate.org/wp-content/uploads/2023/10/maxresdefault-2023-10-15T012904.475-660x400.jpg)
Introduction:
Calculating age from date of birth may seem like a daunting task, but with Microsoft Excel’s built-in functions, it becomes a breeze. In this article, we will explore different methods to accomplish this using Excel’s features such as DATEDIF, YEARFRAC, and a combination of functions.
Method 1: Using DATEDIF Function
Step 1:
Begin by entering the dates in the appropriate cells (e.g., A2:A10). You can type in the dates or use a function like =TODAY() for today’s date.
Step 2:
Click on an empty cell where you want the age to be displayed (e.g., B2).
Step 3:
Type the following formula in the cell:
`=DATEDIF(A2, B2, “y”)`
where A2 is the cell containing the date of birth and B2 is the cell containing today’s date.
Step 4:
Press Enter to see the age in years. Drag this formula down to calculate ages for multiple dates just by clicking on the bottom right corner of the cell and dragging it down.
Method 2: Using YEARFRAC Function
Step 1:
Enter the dates just like you did in method 1.
Step 2:
Click on an empty cell where you want the age to be displayed (e.g., B2).
Step 3:
Type this formula into that cell:
`=INT(YEARFRAC(A2, B2))`
where A2 has the date of birth and B2 has today’s date.
Step 4:
Press Enter and extend the formula to other cells if needed.
Method 3: Combining Functions
This method is helpful when you want age in years, months, and days.
Step 1:
Enter your dates as explained earlier.
Step 2:
Click on an empty cell where you want the age displayed (e.g., B2).
Step 3:
Type the following formula:
`=DATEDIF(A2, B2, “y”) & ” Years, ” & DATEDIF(A2, B2, “ym”) & ” Months, ” & DATEDIF(A2, B2, “md”) & ” Days”`
Make sure to replace A2 and B2 with the corresponding cells containing date of birth and today’s date.
Step 4:
Press Enter and extend the formula for other cells if needed.
Conclusion:
Now you know three different methods to calculate age from date of birth in Excel. Pick the one that fits your requirements best and simplify your calculations with ease. Excel has powerful built-in functions that can save you time and effort in performing complex tasks like this.