How to Calculate Average Age in Google Sheets (With Example)


Often you may want to calculate the average age in Google Sheets based on a list of birth dates.

For example, suppose you would like to know the average age of people in the following dataset:

The following step-by-step example shows how to calculate the average age.

Step 1: Enter the Data

First, let’s enter the date of births for 10 individuals:

Step 2: Convert Date of Birth to Age

Next, we can type the following formula into cell C2 to calculate the age of the first individual:

=YEARFRAC(B2,NOW())

We can then click and drag this formula down to each remaining cell in column C:

Step 3: Calculate Average Age

Next we can type the following formula into cell E2 to calculate the average age of all individuals in this list:

=AVERAGE(C2:C11)

The following screenshot shows how to use this formula in practice:

We can see that the average age of these individuals is 46.757 years old.

If you would instead like to display the average age in terms of years and months, you can type the following formula into cell F2:

=INT(E2) & " years, " & INT((E2-INT(E2))*12) & " months"

The following screenshot shows how to use this formula in practice:

calculate average age in Google Sheets

We can see that the average age of these individuals is 46 years and 9 months old.

Additional Resources

The following tutorials explain how to perform other common tasks in Google Sheets:

Google Sheets: How to Average Across Multiple Sheets
Google Sheets: Calculate Average If Between Two Dates
Google Sheets: How to Calculate Average Excluding Outliers

Leave a Reply

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