Below we outline the steps on how to calculate someone's age in Google Sheets:
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.
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.
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.
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.
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.
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:
The YEARFRAC function can give you a more precise age, including the fraction of the year, not just whole years.
=YEARFRAC(A1, TODAY())
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.
