How to Calculate Age in Google Sheets

Last Updated: 26 February 2026

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

1. Open your Google Sheet.

2. Ensure you have a column with names and a column with birthdates.

1. Click on the cell where you want to display the age (e.g., C2).

2. Type the following formula:

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

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

If you want to know the exact age (Years, Months, Days) Put this in the age cell (assuming DOB in B2):

=DATEDIF(B2, TODAY(), "Y") & "y " &DATEDIF(B2, TODAY(), "YM") & "m " &DATEDIF(B2, TODAY(), "MD") & "d"

This returns a human-readable age like “20y 5m 15d.”

1. Click on the cell with the age calculation (C2).

2. Double-click the fill handle (small square at the bottom-right corner of the cell) to automatically copy the formula down the column.

1. Check a few entries to ensure the age calculations are correct.

2. Confirm the formula adapts correctly to different birthdates.

Example

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

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.

If you want to know the age as of a specific date (e.g., Dec 31, 2025):

=DATEDIF(B2, DATE(2025,12,31), "Y")

You can know the days until next birthday by using the formula below (DOB in B2):

=DATE( YEAR(TODAY()) + (DATE(YEAR(TODAY()), MONTH(B2), DAY(B2)) < TODAY()), MONTH(B2), DAY(B2)) - TODAY()

This returns 0 on the birthday, otherwise the days remaining.