How Do I Add 7 Days to a Date in Excel (5 Methods)

Get FREE Advanced Excel Exercises with Solutions!

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.

Dataset on how do I add 7 days to a date in Excel

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.

Apply Fill Series Feature to add 7 days to a date in Excel

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.

Formatted Cells to add days to a date in Excel

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

Added 7 days to the previous date successfully in Excel

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.

how do I subtract 7 days from a date in Excel

  • Finally, you will get the following result.

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


Similar Readings


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.

Use of Generic Formula to add 7 days to a date in Excel

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

Using Generic Formula to Subtract 7 days from a date in Excel

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

Adding 7 Days to a date with TODAY function in Excel

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

Applying TODAY Function to Subtract 7 days from a date in Excel

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

Use DATE Function to Attach 7 Days to a date in Excel

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.

Use DATE Function to Remove 7 Days from a date in Excel

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

Utilize Paste Special Feature to Connect 7 Days to a Date in Excel

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

Result to Use Paste Special Feature to Connect 7 Days to a Date in Excel


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.

Use Excel VBA to Add 7 Days to a Date

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

Practice Section to add 7 days to a date in Excel


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

Asikul Himel
Asikul Himel

Hi! I am Asikul Islam Himel. Glad you are here. I am a Team Leader of ExcelDemy, running an excellent team of five efficient Excel & VBA Content Developers. Here at ExcelDemy, we give the best sustainable solutions by posting articles related to MS Excel-related problems. I have completed my under graduation degree from Bangladesh University of Engineering and Technology and my program was Naval Architecture and Marine Engineering. I have found passion in data analysis and research-based fields. I am currently working to grow my leadership quality. I have a great interest in project management and critical thinking. In my free time, I love to travel and read books.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo