Add or Subtract Weeks to a Date in Excel & Google Sheets
Download Example Workbook
Download the example workbook
This tutorial will demonstrate how to add (or subtract) weeks in Excel & Google Sheets.
Add Weeks to a Date
Excel stores dates as serial numbers; each whole number representing an unique day. That makes adding days to dates incredibly easy. To add weeks to a date, we will add in 7-day increments.
Add 1 Week
This example will add 1 week (7 days) to a date:
=B3+7*1
Add 5 Weeks
This example will add 5 weeks (7*5=35 days) to a date:
=B3+7*5
Subtract Weeks From a Date
We can subtract weeks in the same way.
Subtract 5 Weeks
This example will subtract 5 weeks (7*5=35 days) from a date:
Adding Weeks in Google Sheets
The above examples work exactly the same in Google Sheets as in Excel:
