In this article:

How to Calculate Age in Google Sheets (2024 Guide)

May 8, 2024

How to Calculate Age in Google Sheets

Below we outline the steps on how to calculate someone's age in Google Sheets:

1. Input the Birth Date

First, make sure you have the birthdate entered in a cell in your Google Sheets. Let's assume you have a birthdate in cell A1 of your Google Sheets, and it's 1/1/2000.

how to calculate age in google sheets

2. Use the TODAY and DATEDIF Functions

Google Sheets has a function called TODAY() which returns the current date. The DATEDIF function can be used to calculate the difference between two dates.

3. Enter the Formula

Click on the cell where you want the age to be displayed. Type =DATEDIF(A1, TODAY(), "Y")

calculate age in google sheets

This formula calculates the difference in years ("Y") between the birth date (A2) and today's date. After entering the formula, press Enter. Google Sheets will display the age based on the birthdate in cell A2.

calculate age google sheets

5. Format the Cell (Optional):

If you want, you can format the cell to make sure it displays as a number. Click on the cell or column and go to Format > Number

how to calculate age google sheets

6. Drag to Fill (Optional):

If you have a list of birth dates in column A, you can drag the corner of the cell (small blue circle at the bottom-right) with the formula to fill down the formula to other rows.

how do i calculate age in google sheets
calculate age in google sheets formula

Other Methods to Calculate Age in Google Sheets

In addition to the DATEDIF function used for calculating age in Google Sheets, there are other methods you can use depending on your specific needs or preferences. Here are some alternatives:

1. Using YEARFRAC Function

The YEARFRAC function can give you a more precise age, including the fraction of the year, not just whole years.


google sheets how to calculate age

2. Calculating Age with Specific Units (Years, Months, Days)

If you want to calculate precise age in terms of years, months, and days, you can use a combination of DATEDIF functions using the syntax below:

=DATEDIF(A1, TODAY(), "Y") & " years, " & DATEDIF(A1, TODAY(), "YM") & " months, " & DATEDIF(A1, TODAY(), "MD") & " days"

formula to calculate age in google sheets

We hope that this article has helped you and given you a better understanding of how to calculate age in Google Sheets. If you enjoyed this article, you might also like our articles on how to use ISNA in Google Sheets and how to use XLOOKUP in Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->