You can use the **EDATE()** function in Excel to quickly add a certain number of months to a date.

This formula uses the following basic syntax:

**EDATE(start_date, months)**

where:

**start_date**: The starting date**months**: The number of months to add to the starting date

For example, we can use the following syntax to add 10 months to the date in cell A1:

**=EDATE(A1, 10)
**

The following example shows how to use this function in practice.

**Example: Add Months to Date in Excel**

Suppose we have the following list of dates in Excel:

We can type the following formula into cell **B2** to add three months to the date in cell **A2**:

=EDATE(A2, 3)

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

By default, Excel will display the dates in a numerical format.

To display the dates in a recognizable date format, highlight the cells in the range **B2:B11**, then click the **Number format** dropdown arrow and choose **Short Date**:

The dates will then be formatted correctly:

Notice that each of the values in column B show the value of the date in column A plus three months.

Note that you can also use negative numbers to subtract months from a date.

For example, we could type the following formula into cell **B2** to subtract three months from the date in cell **A2**:

=EDATE(A2, -3)

Now each of the values in column B shows the value of the date in column A minus three months.

**Note**: You can find the complete documentation for the **EDATE()** function here.

**Additional Resources**

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

How to Convert Days to Months in Excel

How to Calculate Average by Month in Excel

How to Calculate the Number of Months Between Dates in Excel