Return to Excel Formulas List

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 Main Function

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:

Add one WeekAdd 5 Weeks
This example will add 5 weeks (7*5=35 days) to a date:

Add Five WeekSubtract Weeks From a Date
We can subtract weeks in the same way.

subtract Week

Subtract 5 Weeks

This example will subtract 5 weeks (7*5=35 days) from a date:

subtract Five Weeks

Adding Weeks in Google Sheets

The above examples work exactly the same in Google Sheets as in Excel:

Add weeks Google Sheet