How to Determine Age in Excel with this Formula

Learn how to use the DATEDIF function in Excel to quickly determine someone's age based on their date of birth. Understand the correct syntax for the function and remember to format the date correctly before using it. A beginner's guide to determining age with Excel.

Tired of nonsense pricing of DocuSign?

Start taking digital signatures with BoloSign and save money.

If you have ever needed to quickly compute someone's age based on their date of birth, then you know how helpful it can be to have a formula that can do this for you. Excel makes this easy with the DATEDIF function, which can calculate the difference between two dates in terms of years, months, and days.

To use the DATEDIF function, all you need to do is enter the starting date (the date of birth) and the ending date (the current date), and then specify the interval type you want to use (in this case, "y"). The syntax for the DATEDIF function in Excel is as follows:

=DATEDIF(start_date, end_date, interval_type)

So if we wanted to calculate someone's age based on their date of birth, we could use the following formula:

=DATEDIF(A1, TODAY(), "y")

This formula will return the number of years between the date in cell A1 (the date of birth) and today's date. If the person has not yet had their birthday this year, the result will be one less than their actual age.

It's important to remember that the DATEDIF function will only work if the date of birth is entered as a valid date, so make sure the data is formatted correctly before using the formula. In addition, this function only works in Excel versions 2019 and later, so if you're using an older version, you'll need to use a different method.

In conclusion, the DATEDIF function in Excel is a quick and easy way to determine someone's age based on their date of birth. Just remember to format the date correctly, and make sure you're using a compatible version of Excel before using the formula.

Paresh Deshmukh

Co-Founder, BoloForms

30 Jan, 2023

Take a Look at Our Featured Articles

These articles will guide you on how to simplify office work, boost your efficiency, and concentrate on expanding your business.