# How to Add 30 Days to a Date in Excel – 7 Quick Methods

30 or any number of days can be added to a date, using different functions

### Method 1 – Using an Algebraic Formula to Add 30 Days to a Date

Steps:

• Cell C5 and enter:
=B5+30
• Press Enter, to see the 1st date value.
• Drag the Fill Handle to autofill the rest of the cells in Column C.

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

### Method 2 Inserting the EDATE Function to Add 28/29/30/31 Days to a Date

The EDATE function is used to find the same date for next month.Â  28 or 29 days will be added for February and 30 or 31 days will be added the other months.

Steps:

• In C5, enter the EDATE formula.
=EDATE(B5,1)
• Press Enter and autofill the entire column to see the output.

### Method 3 – Using the Paste Special Option to Add 30 Days to a Date

Step 1:

• Select Â D7 (cell containing the number of days to add).
• Press CTRL+C to copy it.

Step 2:

• Select the cells containing the dates.
• Select Option and choose Paste Special.

Step 3:

âž¤ In Paste, select Values.

âž¤ Press Enter.

The new dates will be displayed in Column B.

### Method 4 – Adding 30 Days to the Current Date Using the TODAY Function

Steps:

• In C5, enter:
=TODAY()+30
• Press Enter to see the output.

### Method 5- Using the WORKDAY Function to Exclude Weekends & Customized Holidays

The WORKDAY function willÂ exclude weekends & holidays while counting days between two dates or adding days to a particular date. In Column E,Â  several holidays were added.

Steps:

• In C5, enter:
=WORKDAY(B5,30,\$E\$5:\$E\$9)
• Press Enter and autofill the entire column to see the output.

Inside the WORKDAY function, the 1st argument is the original date, the 2nd argument the number of days that will to be added or subtracted and the 3rd argument includes the holidays that have to be omitted during the addition.

### Method 6 – Using the WORKDAY.INTL Function to Exclude Customized Weekends & Holidays

By using the WORKDAY.INTL function, you can also customize weekends.

Steps:

• In C5, enter:
=WORKDAY.INTL(B5,30,7,\$E\$5:\$E\$9)
• Press Enter and autofill the entire column to see the output.

### Method 7 – Embedding VBA Codes to Add 30 Days to a Date in Excel

Step 1:

• Select the cells containing the dates.

Step 2:

• âž¤ Press ALT+F11 to open the VBA window.
• âž¤ In the INSERT tab, select Module.

Step 3:

• In the module, enter the following codes:

Dim cell As Range
For Each cell In Selection.Cells
cell.Value = cell.Value + 30
Next cell

End Sub
• ClickÂ  PlayÂ or press F5.

Step 4:

• In your Excel worksheet press Alt+F11.
• The new dates will be displayed.

## Related Articles

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

Get FREE Advanced Excel Exercises with Solutions!