To calculate age in Google Sheets, you can use the DATEDIF function or a combination of other functions such as YEAR, MONTH, and DAY. Here are two methods:

Method 1: Using DATEDIF Function

Assuming you have the birthdate in cell A1, you can use the DATEDIF function to calculate the age:

=DATEDIF(A1, TODAY(), “Y”)

This formula calculates the difference in years between the birthdate in cell A1 and the current date (TODAY() function).

Method 2: Using YEAR, MONTH, and DAY Functions

You can also use a combination of the YEAR, MONTH, and DAY functions:

=YEAR(TODAY()) – YEAR(A1) – IF(MONTH(TODAY()) < MONTH(A1) OR (MONTH(TODAY()) = MONTH(A1) AND DAY(TODAY()) < DAY(A1)), 1, 0)

This formula calculates the age by subtracting the birth year from the current year and adjusts for the birth month and day.

Note:

  • Replace A1 with the actual cell reference where the birthdate is located in your Google Sheet.
  • Both methods assume the birthdate is entered as a date in the cell (formatted as Date).

Copy and paste the desired formula into a cell in your Google Sheet, and it will calculate the age based on the provided birthdate.

Leave a Reply

Your email address will not be published. Required fields are marked *