Often you may want to calculate the average age in Excel 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.265** 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:

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

**Additional Resources**

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

How to Calculate the Number of Months Between Dates in Excel

How to Convert Date to Month and Year Format in Excel

How to Calculate Average by Month in Excel