• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

TheAppTimes

App Reviews, Tutorials, & Gadget News Hub

  • Gadgets
  • How To
  • Apps
  • Software
  • IT
  • Guides
  • Gaming
  • Show Search
Hide Search
Home » How To » How to Calculate the Age of a Person in Excel

How to Calculate the Age of a Person in Excel

October 18, 2016

If you’re working with a lot of employee data and need to create an maintain a database with the employee’s ages, automatically updated every year, you can make use the the functions in Excel to do it. For this purpose all you need is the year of their birth or their date of birth. In this tutorial, I’ll show you how to calculate the age of a person in Excel when you have this information.

How to Calculate the Age of a Person with the Year of Birth

If you only have the year of birth of a person, you can make use of the YEAR function to calculate the age of a person. Let’s assume that we have the year of birth in cell A1 and we want the age displayed in cell C1.

1. In cell C1, type =YEAR(TODAY())-A1

2. Hit Enter to get the result.

Here, what you are doing is, subtracting the year of birth from the current year to get the age.

How to Calculate the Age of a Person with the Year of Birth

How to Calculate the Age of a Person with the Date of Birth

In most situations, you will have the date of birth of a person at hand. In such situations, you can extend the above formula to find the age. Here we use the YEAR function to get the year from the person’s birth date and then subtract the current year to get the result.

In cell A2, let’s assume you have the date of birth as 10/10/1980. Here’s what you need to do.

1. In cell C2, type =YEAR(TODAY())

ALSO READ:  Excel 2010: How to Compare Two Strings of Text for Similarities

2. Then add a minus sign and type YEAR( so the formula looks like this: =YEAR(TODAY())-YEAR(

3. Then select cell A2 and enter the closing parenthesis. The formula now reads: =YEAR(TODAY())-YEAR(A2)

4. Hit Enter.

Excel will format the result as a date, which is looks like this; not exactly what we want.

How to Calculate the Age of a Person with the Date of Birth

We need to format the cell as a regular number.

5. With the cell selected, on the Home tab, in the Number group,  select General.

That’s it!
format-as-general

You now have the age of the person in a jiffy.

If you found this tutorial helpful, be sure to check out more good stuff in our Learn Excel series. If you want to learn Excel from scratch, consider taking up our Udemy course, Excel 2016 for Beginners. It is available at a nominal price of just $10.

Tweet10
Share2
WhatsApp
Pin2
Buffer
14 Shares

Filed Under: How To Tagged With: excel how to, learn excel

You May Also Like

Ways to Use Excel Mobile - TATFI
10 Creative Ways to Use Excel Mobile in your Business
How to Get Rid of the Paste Options Menu in Word, Excel and PPT
How to Get Rid of the Paste Options Menu in Word, Excel and PPT
How to Calculate Number of Days Between Two Dates in Excel
How to Calculate Number of Days Between Two Dates in Excel

About Adeline Gear

Adeline is a tech enthusiast who loves exploring the latest tools and applications in the marketplace. She also loves her Android and spends time reviewing apps and playing games when she has the time.

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Hottest New Gadgets!

Lenovo Legion Go - TAT

Lenovo Legion Go: A Powerful Windows Gaming Handheld Launching in Oct 2023

Best Accessories for the Galaxy Z Fold 5 - TAT

The Best Accessories for the Galaxy Z Fold 5

Withings ScanWatch 2 - TAT

Everything You Need to Know About the Withings ScanWatch 2

Starfield Streaming gear - TAT

Elgato Unveils Limited-Edition Starfield Streaming Gear

Samsung PRO Ultimate Memory Cards - TAT

The New Samsung PRO Ultimate Memory Cards Offer Unmatched Speed for Professionals

Popular Tags

android android apps android games android how to apple casino games chrome extensions excel excel how to facebook fitness wearable gadgets gaming gmail google ios apps ios games ios how to ios tips ipad iphone kids apps learn excel management microsoft new releases outlook how to photo apps powerpoint how to productivity Samsung security smartphone smartphones smartwatches software tablet tablets technology twitter web browsers windows 10 word how to xbox youtube

Disclosure

TheAppTimes is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for us to earn fees by linking to Amazon.com and affiliated sites.
Personalize Your Hardware with Razer Skins - TAT

Personalize and Protect Your Gaming Hardware with these Stylish Razer Skins

Best Controllers for Xbox Cloud Gaming - TAT

Best Controllers for Xbox Cloud Gaming

Starfield - TAT

Starfield: Get Ready to Experience a New Frontier in Gaming

Razer Cobra Pro - TAT

Razer Cobra Pro: A Great Gaming Mouse for Competitive Gamers

Best gaming monitors 2023 - TAT

The Best Gaming Monitors for a Truly Immersive Experience

Hot on Amazon

TheAppTimes © 2023 // Runs on StudioPress

  • About
  • Contact
  • Privacy Policy
  • Template Gallery