Calculate age from date of birth
When asked about your age, you calculate it from your birth date to today’s date, right? 😊
There are different methods how to calculate age in Excel. But don’t get overwhelmed by thinking you have to learn it all. We’ll only focus on the basic and most used ones.
The most commonly used method in calculating age from date of birth in Excel is through the YEARFRAC function coupled with the INT function and TODAY function.
The syntax of the YEARFRAC function is:
=YEARFRAC (start_date, end_date, [basis])
With the following arguments below:
- start_date – the start date or birth date
- end_date – the end date, use the TODAY function for today’s date or the current date.
- basis – optional; the type of day count basis; default is 0 where days between 2 dates are counted in a 360-day year with all months considered having 30 days; 1 uses the actual days.
The YEARFRAC function returns a decimal value which is the fractional years between two dates.
Since the result would be in decimal, we would wrap the YEARFRAC function with the INT function which turns a decimal into the nearest integer.
With that, this is the final age formula we’ll be using:
=INT(YEARFRAC(birth date,TODAY(), 1))
Okay, enough technical talk, let’s try the formula with some real data 💪
Open your practice workbook and let’s calculate the age from their birth dates to today’s date.
When working with the age formula in your own workbooks, make sure that the birth dates are in date format.
In our workbook, the birth dates are already in date format. So, let’s start!
- Double-click cell C2.
- Type the above formula in our cell.
- Type 1 for the basis. Complete the formula by typing two right parentheses.
- Press Enter.
And there we have it! Majid is 29 years old 👍
Quickly calculate the ages of the others by double-clicking or dragging down the fill handle.
That’s how you calculate age in Excel from the birth date. All it took us is combining the INT, YEARFRAC, and TODAY functions into a single formula to calculate it.
See? No more manual calculations. Let Excel do it for you 😊