How To Calculate Age In Google Sheets

Last Updated on October 31, 2023 by Jake Sheridan

In this tutorial, you will learn how to calculate age in Google Sheets.

It’s more complicated than simply taking the birth year and subtraction the present year. There are many factors you should take into account.

You might need to estimate a group of people’s ages based on their dates of birth in a variety of circumstances. There are many methods to do this, which you might find in this tutorial

Once ready, we’ll get started by utilizing real-world examples to show you how to calculate age in Google Sheets.

How To Calculate Age In Google Sheets

Before we begin we will need a group of data to be used to calculate age in Google Sheets.

Method 1

The first method is to use the DATEIF function to calculate age. The DATEDIF function determines the difference between two dates.

Step 1

First, you need to have a clean and tidy group of data to work with.

Step 2

To calculate the age, click on the cell you want to insert your formula in, then key in this formula =DATEDIF(B3,B4,”Y”).

Step 3

Once you have pressed ‘Enter’, the formula will return the age.

Method 2

The second method is to use the YEARFRAC function. When two dates are provided, the YEARFRAC function provides the years between them, including fractions of a year. You can choose from a variety of day-counting techniques. The age of a person can be determined using this function.

Step 1

First, you need to have a clean and tidy group of data to work with.

Step 2

To calculate the age, click on the cell you want to insert your formula in, then key in this formula =YEARFRAC(B11,TODAY()).

Step 3

Once you have pressed ‘Enter’, the formula will return the age.

Summary

That’s all there is to it. You are welcome to copy the example spreadsheet below to see how it is done. The most crucial lesson is to enjoy yourself while doing it.

Example Spreadsheet: Make a copy of the example spreadsheet

In this tutorial, I covered how to calculate age in Google Sheets. Want more? Check out all the Google Sheets Tutorials.