To keep timely records of your work, you need to add dates to your worksheet. If you manually add your date sometimes this process becomes very painful and irritating. To save time and increase your efficiency, you can add months or years to date using some specific functions in Excel. This is quite important when you are dealing with large date-based assignments. Today in this article, I will show you how do I add 7 days to a date in Excel.
Furthermore, for conducting the session, I will use Microsoft 365 version.
Here, you can add a certain number of days to an existing date by applying some built-in Excel features and functions. Now, let’s consider a situation where you are working in an online bookstore and after every seven days, you have to deliver certain books to some customers.
So, you can apply some Excel functions or features to insert those delivery dates automatically. Now, let’s discuss those methods.
1. Applying Fill Series Feature to Add 7 Days to a Date in Excel
Fill Series is an amazing method that you can apply to add 7 days to a date in Excel. Now, in the following example, I have a dataset containing the columns “Book Name”, “Price”, and “Delivery Date”. At this time, I need to add 7 days to a specific date in the Delivery Date column.
But first, I need to change the format of the Delivery Date column.
- So, to do this, go to the Home tab >> from the Number group >> click on the drop-down arrow to open different formats >> then select More Number Formats to continue.
As a result, a new dialog box named Format Cells popped out.
- Then, from the Category section >> select Date.
- After that, from the Type section >> choose the date format you like.
- Then, press OK.
- Now, write down the 1st delivery date in the D5 cell.
- First, select the cells D5:D18.
- Then, go to the Home tab >> In the Editing ribbon >> click on Fill >> then select Series.
As a result, you will see a new dialog box named Series.
- Then, in Series Formatting Window, check on Columns, Date, and Days.
- Subsequently, increase the Step value to 7 and click OK.
- And I have added 7 days to the previous date successfully.
Here, you can also subtract days to date using the same procedure.
- Now, just change the Step value from 7 to -7.
- After that, click OK to get the result.
- Finally, you will get the following result.
Read More: How to Add 30 Days to a Date in Excel (7 Quick Methods)
Similar Readings
- How to Add 6 Months to a Date in Excel (2 Easy Ways)
- Add Months to a Date in Excel (2 Ways)
- How to Add Days to a Date in Excel Excluding Weekends (4 Ways)
- Calculate Number of Days Between Two Dates in Excel
- How to Calculate Working Days Excluding Sundays in Excel
2. Adding 7 Days to a Previous Date in Excel
You can also add 7 days to a date using a simple trick by adding 7 to the previous date. Let’s learn this method using two different ways.
2.1. Using Generic Formula
Here, I will use the previous example to perform this task.
- At first, follow the steps of method-1 to change the Delivery Date column format and add the 1st delivery date in the column.
- Then, in cell D6, apply the following formula.
=D5+7
Here, this formula will add seven days to the previous date repeatedly.
- Subsequently, press ENTER to get the result.
- Now take your mouse cursor to the bottom right corner of cell D6. When the cursor shows the cross sign (+), which is called Fill Handle.
- Then, double-click on this Fill Handle icon to apply the same formula to the rest of the cells.
- Lastly, you will get all the delivery dates.
- Similarly, you can also perform subtraction using the same formula. In this case, just change the formula to this.
=D5-7
- Then, press ENTER.
- Then double-click on the Fill Handle icon to get the final result.
Read More: How to Add Days to Date Using Excel Formula (5 Easy Ways)
2.2. Adding Days with TODAY Function
Now, let’s assume that you need to add 7 days to today.
- First, to do this, add a new column “Days Remained” where the days are mentioned from today’s delivery date.
- Then, in cell E5, apply the TODAY function. The formula is:
=TODAY()+D5
Here, using this function, the numbers from the Days Remained column will be added automatically with Today (present date).
- After that, press ENTER to get the result.
- Now, you can drag the Fill Handle icon to AutoFill the corresponding data in the rest of the cells E6:E18.
- As a result, you will see all the delivery dates.
- Again, using the same way, you can subtract 7 days from today’s date. Just change the formula to this,
=TODAY()-D5
- Then, press ENTER.
- Consequently, drag the Fill Handle icon to apply the same formula to the rest of the cells.
Read More: How to Calculate 90 Days from a Specific Date in Excel
3. Inserting DATE Function to Attach 7 Days to a Date in Excel
The DATE function is an effective function to add years, months, or days to a date. So, I will use this function to add 7 days to a specific date.
- Firstly, add the first delivery date manually.
- Secondly, in cell D6, apply the DATE function. So, insert the values and the final formula is:
=DATE(YEAR(D5),MONTH(D5),DAY(D5)+7)
- Thirdly, press ENTER.
Formula Breakdown
- Where the YEAR function looks at the date in cell D5.
- Output: 2021.
- Then, the MONTH function returns the month value from cell D5.
- Output: 9.
- Then, DAY(D5)+7—> the DAY function returns the day value from cell D5. It then adds 7 days to the given date.
- Output: 35.
- Lastly, DATE(2021,9,35) returns 44474. Which represents October 5, 2021.
- After that, do the same for the rest of the cells.
- In the same way, you can also subtract days from a given date using the same DATE function. Just add “-7” instead of “7” in the formula.
=DATE(YEAR(D5),MONTH(D5),DAY(D5)-7)
- Then, press ENTER.
- Similarly, do the same for the rest of the cells.
Read More: How to Add 2 Years to a Date in Excel (3 Easy Methods)
4. Using Paste Special Feature to Add 7 Days to a Date in Excel
You can use the Paste Special option to add 7 days to a date in Excel. But, to do so, at first you have to modify your dataset. So, follow the steps given below.
Steps:
- Firstly, write 7 in the F5 cell. As to you want to add 7 days.
- Secondly, write the 1st delivery date in the D5 cell.
- Thirdly, copy the date to the D6 cell.
- Then, copy the F5 cell by pressing CTRL+C.
- Consequently, select the date which is in the D6 cell.
- After that, right-click on the Mouse.
- Then, from the Context Menu Bar >> choose Paste Special option.
As a result, you will see a new dialog box named Paste Special.
- First, choose Values from the Paste option.
- Then, select Add from the Operation option.
- Subsequently, press OK.
Finally, you will see the 2nd delivery date.
- Then, select both cells D5, and D6.
- After that, drag the Fill Handle icon to AutoFill the corresponding data in the rest of the cells D7:E18.
- Finally, you will get the following result.
5. Using Excel VBA to Add 7 Days to a Date
The most interesting part is that you can use the VBA code to add 7 days to a date in Excel. The steps are given below.
Steps:
- Firstly, you have to choose the Developer tab >> then select Visual Basic.
- Now, from the Insert tab >> you have to select Module.
- At this time, you need to write down the following Code in the Module.
Sub Adding_7_Days()
Dim my_cell As Range
For Each my_cell In Selection.Cells
my_cell.Value = my_cell.Value + 7
Next my_cell
End Sub
Code Breakdown
- Here, I have created a Sub procedure named Adding_7_Days.
- Next, I have declared a variable my_cell as Range to call the range.
- Then, I used the For Each loop to repeat the operation, Cells to select the cells, and then add 7.
- Now, you have to save the code by pressing CTRL+S and the code extension will be .xlsm.
- Then, you need to go to the Excel worksheet.
- Subsequently, select the cells where you want to add 7.
- After that, from the Developer tab >> go to Macros.
- Then, choose Macro name (Adding_7_Days).
- After that, press Run.
- Lastly, you will see these cell values have increased by 7.
Things to Remember
📌 Change the format of the cells using the “Date” option in the Number ribbon.
📌 If the “Days” is not an integer, then the integer value before the decimal point is considered.
Practice Section
Now, you can practice the explained method by yourself.
Download Practice Workbook
Download this practice sheet to practice while you are reading this article.
Conclusion
Here, how do I add 7 days to a date in Excel is discussed, here in this article. I hope that you will find a solution to your problem in this article. If you have any thoughts or confusion regarding this article, you are welcome to comment.
Further Readings
- How to Subtract Dates in Excel to Get Years (7 Simple Methods)
- Calculate Working Capital Days in Excel (with Easy Steps)
- How to Find Number of Weeks Between Two Dates in Excel
- Add 3 Months to a Date in Excel (4 Easy Methods)
- How to Add 3 Years to a Date in Excel (3 Effective Ways)
- Count Days from Date to Today Automatically Using Excel Formula
- How to Use DateDiff Function in Excel VBA (5 Examples)