How to calculate age in excel in dd/mm/yyyy

Calculating ages can be a tedious affair if you’re doing it manually. Luckily, Excel provides several functions and techniques to calculate age based on a person’s date of birth using the current date or a specific date.

Using these tools, you can generate precise age calculations with ease.

In this guide, we will explore different methods to calculate age in Excel, accommodating both the current date and specific reference dates.

Aging formula in excel from today

Read on to learn more.

How To Calculate Age in Excel

Here’s how Excel can calculate DOB to age:

1. In a cell, type in the “equals” sign (=) and the “DATEDIF” function.
2. Select the cell with the date of birth.
3. Add a comma and write the “TODAY” function.
4. Add another comma and “y” in quotation marks to return the results in years.
5. Press “Enter” and drag the formula down to copy it.

How Do You Calculate Age in Excel?

(Which Functions)

There are a couple of different functions you can use in Excel to calculate age, just like in Google Sheets. The most commonly used function is the “

how to find due date in excel

how to count due date in excel