21.9 C
London
Tuesday, July 22, 2025
HomeSoftware TutorialsExcelHow to Add Months to Date in Excel (With Examples)

How to Add Months to Date in Excel (With Examples)

Related stories

Learn About Opening an Automobile Repair Shop in India

Starting a car repair shop is quite a good...

Unlocking the Power: Embracing the Benefits of Tax-Free Investing

  Unlocking the Power: Embracing the Benefits of Tax-Free Investing For...

Income Splitting in Canada for 2023

  Income Splitting in Canada for 2023 The federal government’s expanded...

Can I Deduct Home Office Expenses on my Tax Return 2023?

Can I Deduct Home Office Expenses on my Tax...

Canadian Tax – Personal Tax Deadline 2022

  Canadian Tax – Personal Tax Deadline 2022 Resources and Tools...

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:

Excel add months to date

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)

Excel subtract months from date

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

Subscribe

- Never miss a story with notifications

- Gain full access to our premium content

- Browse free from up to 5 devices at once

Latest stories