How to Add 30 Days to a Date in Excel (7 Quick Methods)

In Microsoft Excel, by using different functions you can easily add 30 or any number of days to a particular date. In this article, you’ll learn a number of useful methods to add 30 or any number of days to a date in Excel.

add 30 days to a date in excel overview

The above screenshot is an overview of the article which represents an example of how you can add 30 days to a number of dates in an Excel worksheet. You’ll learn more about all suitable functions in the following methods in this article.


Download Excel Workbook

You can download the Excel workbook that we’ve used to prepare this article.


7 Simple Ways to Add 30 Days to a Date in Excel

1. Using Algebraic Formula to Add 30 Days to a Date

To add a particular number of days to a date, first of all, we can simply use algebraic addition. In the picture below, some dates are present in Column B. In Column C, we’ll find out the next date by adding 30 days from the original dates.

📌 Steps:

➤ Select Cell C5 & type:

=B5+30

➤ Press Enter, you’ll get the 1st date value.

➤ Now use Fill Handle to autofill the rest of the cells in Column C & you’re done.

add 30 days to a date with algebraic formula addition


2. Inserting 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. Thus, 28 or 29 days will be added for February based on the leap year factor. Similarly, 30 or 31 days will be added based on the total days of the following month. But here you cannot manually add 30 days to each date, you can only set the following month to add 28/29/30/31 days to the original date.

📌 Steps:

➤ In Cell C5, the related EDATE formula will be:

=EDATE(B5,1)

➤ Press Enter, autofill the entire column & you’ll find the results.

add 30 days to a date with edate function


3. Using Paste Special Option to Add 30 Days to a Particular Date

Unless you want to use a separate column to add 30 days to the dates, then you can use the Paste Special option.

📌 Step 1:

➤ Select Cell D7 where the number of days to be added is present.

➤ Copy the cell by pressing CTRL+C.

add 30 days to a date with paste special

📌 Step 2:

➤ Now select the cells containing the dates.

➤ Press the Option key & choose Paste Special, a dialogue box will appear.

add 30 days to a date with paste special

📌 Step 3:

➤ Select the Values radio button from the Paste options.

➤ Select Add radio button from the Operation types.

➤ Press Enter & you’re done.

add 30 days to a date with paste special

Like in the picture below, you’ll find the new dates at once in Column B.

add 30 days to a date with paste special


4. Adding 30 Days from Current Date by Using TODAY Function

If you need to add 30 days from the current date then you have to simply add 30 with the TODAY function.

📌 Steps:

➤ In Cell C5, you have to type:

=TODAY()+30

➤ After pressing Enter, you’ll get the next date by adding 30 days from the current date.

add 30 days to current date by using today function


5. Using WORKDAY Function to Exclude Weekends & Customized Holidays

The WORKDAY function is really useful when you need to exclude weekends & holidays while counting days between two dates or adding days to a particular date. In Column E, we’ve added several holidays that will be excluded while adding 30 days from the original dates.

➥ Read More: Add days to date in Excel excluding weekends and holidays (4 ways)

📌 Steps:

➤ In Cell C5, the related formula will be:

=WORKDAY(B5,30,$E$5:$E$9)

➤ Press Enter, autofill the entire column C & you’re done.

add 30 days to a date excluding weekends and customized holidays

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


6. Using WORKDAY.INTL Function to Exclude Customized Weekends & Holidays

By using the WORKDAY.INTL function, you can customize weekends too. You’ll see the options with serial numbers for the 3rd argument where different weekend pairs or even single weekends are present. In our example, the weekends are Friday & Saturday which are assigned to the serial number 7 so it has to be mentioned in the 3rd argument of the function.

📌 Steps:

➤ In Cell C5, the related formula with customized weekends as well as holidays will be:

=WORKDAY.INTL(B5,30,7,$E$5:$E$9)

➤ Press Enter, autofill the rest of the cells & you’ll get the entire result right away.

add 30 days to a date excluding customized weekends and holidays


7. Embedding VBA Codes to Add 30 Days to a Date in Excel

You can add 30 or any number of days to a particular date by using the VBA editor too.

📌 Step 1:

➤ Select the cells containing the dates.

add 30 days to a date with vba editor

📌 Step 2:

➤ Press ALT+F11 to open the VBA window.

➤ From the INSERT tab, select the Module option. A new module window will open where you have to type the VBA codes.

add 30 days to a date with vba editor

📌 Step 3:

➤ In the module, type 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 on the Play button or press F5.

add 30 days to a date with vba editor

📌 Step 4:

➤ Return to your Excel worksheet by pressing Alt+F11 & you’ll see the new dates that have been found by adding 30 days to the original dates.

add 30 days to a date with vba editor


Concluding Words

I hope, all of these methods mentioned above will now prompt you to apply them in your regular Excel chores. If you have any questions or feedback, let us know in the comment section. Or you can check out our other interesting & informative articles related to Excel functions on this website.


Further Readings

Nehad Ulfat

Hello, Welcome to my profile. I'm a Technical Content Creator as well as a Naval Architect & Marine Engineer. I have preferences to do analytical reasoning & writing articles on various statistical data. Here, you'll find my published articles on Microsoft Excel & other topics related to my interests!

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo