How to Calculate Age in Google Sheets

Last Updated: 15 November 2024

By: Matt Hayes

Summarize with:
ChatGPTGrokGoogle AI ModePerplexityClaude.ai

Fast navigation

In 4 simple steps, this guide will show you how to calculate age in Google Sheets.

Follow these straightforward methods to get accurate age calculations from birth dates.

So let’s dive in and calculate age in Google Sheets from birth dates!

Steps:

  1. Prepare Your Data
  2. Enter the DATEDIF Formula
  3. Autofill the Formula
  4. Validate Your Results

Step 1: Prepare Your Data

  • Open your Google Sheet.
  • Ensure you have a column with names and a column with birthdates.
screenshot of a google sheet with names in column A and birthdates in column B
Next step

Step 2: Enter the DATEDIF Formula

  • Click on the cell where you want to display the age (e.g., C2).
  • Type the following formula:

=DATEDIF(B2, TODAY(), "Y") Text...

red arrow pointing to DATEDIF formula in C2

Press Enter. This will calculate the age in years based on the birthdate in cell B2 and today's date.

red arrow pointing to the age in C2
BackNext step

Step 3: Autofill the Formula

  • Click on the cell with the age calculation (C2).
  • Double-click the fill handle (small square at the bottom-right corner of the cell) to automatically copy the formula down the column.
red arrow pointing to the fill handle at the bottom-right corner of the cell C2
BackNext step

Step 4: Validate Your Results

  • Check a few entries to ensure the age calculations are correct.
  • Confirm the formula adapts correctly to different birthdates.

Example Text...

After completing these steps, your data should look like this:

red rectangle highlights the ages in column C

That's it! You've successfully calculated ages in Google Sheets.

Now, try it out with your data and make sure everything works as expected.

Back

Finished!