# How to Add Months to the Date in Excel – 5 Examples

The sample dataset showcases Order ID, Order Date, Process Time (Months), and Delivery Date. To automatically calculate delivery dates:

### Example 1 – Using the EDATE Function to Add Months to the Date in Excel

Steps:

• Enter the formula in E5.
`=EDATE(C5, D5)`

Formula Breakdown

Order Dates are in column C and Processing times in column D. C5 is used as starting date and D5 as the number of the month.

[Note: Make sure column D is in Date format]

• Drag down the Fill Handle to see the result in the rest of the cells.

This is the output.

Read More: How to Add 3 Months to a Date in Excel

### Example 2 – Using the MONTH and the Date Functions to Add the Month to a Date in Excel

Steps:

• Enter the formula in E5.
`=DATE(YEAR(C5),MONTH(C5)+D5,DAY(C5))`

Formula Breakdown

The DATE function takes three arguments. Here, you only need to increase the month: in the second argument MONTH(C5)+D5  is used.

• Drag down the Fill Handle to see the result in the rest of the cells.

This is the output.

[Note: Make sure column is in Date format]

Read More: How to Add 6 Months to a Date in Excel

### Example 3 – Combine the COUNTIFS and the EDATE Functions to Add Months to the Date

To count how many orders will be delivered from June 2020 to September 2020:

Steps:

• Enter the formula in F6.
• Press Enter.
`=COUNTIFS(C5:C12,">="&F4,C5:C12,"<"&EDATE(F4,4))`

Formula Breakdown

`COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…)`

The COUNTIFS function counts the cells in C5:C12 ; the condition is up to 4 months after the date in F4, which is calculated by the EDATE function.

Read More: How Do I Add 7 Days to a Date in Excel

### Example 4 – Using the Fill Series Option to Add 1 Month to the Date in Excel

To increase the month by 4 for every order with the starting date: 1/2/2020:

Steps:

• Select C4:C12.
• Go to the Home tab.
• In Editing, select Fill.
• Choose Series.
• Select Columns in Series in.
• Select Date in Type.
• In Date Unit choose Month.
• Enter 1 in Step value.
• Click OK.

This is the output.

Read More: How to Add 30 Days to a Date in Excel

### Example 5 – Run a VBA Code to Add Months to the Date

Steps:

• Press Alt + F11 to open the VBA window.
• Click Insert > Module.

• Enter the following code:
``````Sub AddMonths()
Dim StartDate As Date
Dim mNumber As Integer
Dim Message As String
StartDate = InputBox("Insert the Starting Date")
mNumber = InputBox("Insert Number of Adding Months")
MsgBox Message
End Sub``````
• Click the Run icon.

• In the Macros dialog box, select the macro name and click Run.

• Enter the date in the first input box.
• Click OK.

• Enter the number of months.
• Click OK.

This is the output.

## Related Articles

<< Go Back to Adding Days to Date | Date-Time in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!

Md. Abdullah Al Murad is a computer engineer who loves exploring Excel and VBA programming. Programming, to him, is a time-saving tool for efficiently managing data, files, and internet tasks. He is proficient in C, C++, Python, JavaScript, HTML, SQL, MySQL, PostgreSQL, Microsoft Office, and VBA and goes beyond the basics. He holds a B.Sc. in Computer Science and Engineering from American International University-Bangladesh. He has transitioned into the role of a content developer. Beyond his work, find... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF