You can use the following formula to calculate the number of years and months between two dates in Excel:

**=DATEDIF(A2, B2,"y")&" years "&DATEDIF(A2, B2,"ym")&" months"
**

This particular formula will return the number of years and months between the start date in cell **A2** and the end date in cell **B2**.

For example, if cell **A2** contains **1/4/2005** and cell **B2** contains **1/1/2022** then this formula will return **16 years 11 months**.

The following examples show how to use each formula in practice.

**Example: Calculate Years & Months Between Two Dates in Excel**

Suppose we have the following list of start and end dates in Excel:

Suppose we would like to calculate the number of full years and months between the start and end dates in each row.

We can type the following formula into cell **B2** to do so:

**=DATEDIF(A2, B2,"y")&" years "&DATEDIF(A2, B2,"ym")&" months"**

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

Column C now displays the number of full years and months between the start date and end date in each row.

Note that you can also format the output in a different way if you’d like.

For example, you could use the following formula to add a comma between the years and months:

**=DATEDIF(A2, B2,"y")&" years, "&DATEDIF(A2, B2,"ym")&" months"**

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

The years and months now have a comma in between them in the output of column C.

**Note**: You can find the complete documentation for the **DATEDIF **function in Excel here.

**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