How to Calculate Age in Google Sheets (2024 Guide)

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.

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")

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.

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. 

‍

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.

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.

=YEARFRAC(A1, TODAY())

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"

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.