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.
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.
➤ Select Cell C5 & type:
➤ 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.
Read More: Add Days to Date Using Excel Formula
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.
➤ In Cell C5, the related EDATE formula will be:
➤ Press Enter, autofill the entire column & you’ll find the results.
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.
📌 Step 2:
➤ Now select the cells containing the dates.
➤ Press the Option key & choose Paste Special, a dialogue box will appear.
📌 Step 3:
➤ Select the Values radio button from the Paste options.
➤ Select Add radio button from the Operation types.
➤ Press Enter & you’re done.
Like in the picture below, you’ll find the new dates at once in Column B.
- 3 Suitable Excel Formula to Count Days from Date
- Excel Formula to Calculate Number of Days Between Today & Another Date (6 Quick Ways)
- [Fixed!] VALUE Error (#VALUE!) When Subtracting Time in Excel
- Calculate Number of Days between Two Dates with VBA in Excel
- How to Create a Day Countdown in Excel (2 Examples)
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.
➤ In Cell C5, you have to type:
➤ After pressing Enter, you’ll get the next date by adding 30 days from the current date.
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.
➤ In Cell C5, the related formula will be:
➤ Press Enter, autofill the entire column C & you’re done.
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.
➤ In Cell C5, the related formula with customized weekends as well as holidays will be:
➤ Press Enter, autofill the rest of the cells & you’ll get the entire result right away.
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.
📌 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.
📌 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.
📌 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.
Related Content: How to Add/Subtract Years to a Date in Excel
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.