How to Add Months to a Date in Microsoft Excel

0
29


Want to see what the date will be after a certain number of months have passed? Using Microsoft Excel EDATE function, you can add (or subtract) months to a specific date in your spreadsheets. Here’s how to use it.

RELATED: 13 Microsoft Excel Date and Time Functions You Should Know

How the EDATE function works

in Excel EDATE function, specifies the date (source date) to which you want to add months and the number of months you want to add. Excel then calculates the resulting date and displays it in the selected cell.

To subtract months from a date, enter a negative month number. For example, to remove 3 months from a date, enter -3 (minus three) instead of just 3 .

Add months to a date in Excel

To begin the process of adding months, open your spreadsheet in Microsoft Excel.

In your spreadsheet, select the cell in which you want to see the resulting date.

In your selected cell, type the following function and press Enter. In this function, replace C2 with the cell containing your origin date and C4 with the cell that has the number of months to add.

Advice: Just a reminder to use the “-” (minus) sign before the number of months if you want to subtract months from your date.

=EDATE(C2,C4)

Enter the DATE DATE function.

In your selected cell, you will see the date that occurs after you add your specified number of months.

The result of the EDATE function.

If you see a string of numbers instead of the resulting date, that means your cell isn’t using date formatting. To fix this, on the Excel ribbon at the top, click the “Home” tab. Then, in the “Number” section, click the dropdown menu and choose “Short Date.”

Choose the format "short date".

Are you ready.

And that’s how you know what the date will be after adding a specific number of months to the source date. Very useful!


Did you know that you can also add days instead of months to your dates? Check out our guide to learn how to do it.

RELATED: How to add or subtract dates in Microsoft Excel