Calculate age in Excel

Author

Akash Matubber
September 03, 2024

In partnership with

Today, we will learn how to calculate age in Excel, a useful technique for working with dates and determining someone's age from their birthdate. Many of you might already be familiar with or using this method. If you're one of them, feel free to skip today's edition.

For those who want to calculate relative time in Excel, this tutorial might be helpful.

Looking for unbiased, fact-based news? Join 1440 today.

Upgrade your news intake with 1440! Dive into a daily newsletter trusted by millions for its comprehensive, 5-minute snapshot of the world's happenings. We navigate through over 100 sources to bring you fact-based news on politics, business, and culture—minus the bias and absolutely free.

The process is as follows:

  • Open Excel and Navigate to the cell to calculate age in Excel

  • Type the following formula, =DATEDIF(D5,TODAY(),”Y“) 

  • “Double click” to auto fill

  • Enjoy!!!

That’s how you can Calculate age in Excel. By using the same method you can calculate relative time in Excel as well.

Stay tuned for more Excel tips and tricks in our future issues. Happy calculating!