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 Func

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 one Week

Add 5 Weeks

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

=B3+7*5

Add Five Week

Subtract Weeks From a Date

We can subtract weeks in the same way.

subtract Week

Easy Excel Automation

Add Excel automation to your workbook with just a few clicks.

Learn More

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

Excel Practice Worksheet

practice excel worksheet

Practice Excel functions and formulas with our 100% free practice worksheets!

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!

Free Download

Return to Excel Formulas List