Add or Subtract Weeks to a Date in Excel & Google Sheets

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on July 15, 2023
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:


Add one Week

Add 5 Weeks

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


Add Five Week

Subtract 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

AI Formula Generator

Try for Free

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