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:

• 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.

• Press Enter and autofill the entire column to see the output.

Read More: How to Add Months to Date in Excel

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.

➤ In Operation, select Add.

➤ 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:

• 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:

• 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:

• Press Enter and autofill the entire column to see the output.

Read More: How to Add Days to a Date in Excel Excluding Weekends

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:

Sub Add30Days()

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.

Download Excel Workbook

Download the Excel workbook here.

Related Articles

• How to Add Years to a Date in Excel
• How to Add 2 Years to a Date in Excel
• How to Add 3 Years to a Date in Excel
• How to Add 3 Months to a Date in Excel
• How to Create a Formula in Excel to Change Date by 1 Year
• How to Add 6 Months to a Date in Excel
• How to Add Weeks to a Date in Excel

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