How to add weeks to date in google sheets in 60s or (less)

To add weeks to date in google sheets you can use the ‘+’ operator with several weeks to add.

Here is how to add weeks to a date in google sheets:

1. Open google sheets on your computer or mobile

2. List dates in one column

3. To add +2 weeks to the A1 cell, write a formula in B1

4. Write =A1+2*7

5. Press enter and now B1 will have A1 date+2 weeks


Once you have added 2 weeks to date in the B1 cell, you can do the same for the rest of the cells.


Here is an animation showing this in action:

add weeks to date in google sheets



Table of content



Add weeks to date in google sheets with example

Let’s see an example of add weeks to date in google sheets.

We have a list of dates in column A as you see below:

add weeks to date in google sheets example


We want to add 1 week, 2 weeks, 3 weeks, 4 weeks, 5 weeks, and 6 weeks to these dates. To add weeks, follow the below steps:


Step-1: In column B list the number of weeks to add for each cell

add weeks to date in google sheets step 1


Step-2: Highlight cell B2 in column B where we want to get the result


Step-3: Write the formula =A2+B2*7 in cell C2

add weeks to date in google sheets example


Step-4: Press enter and you will have 1 week added to A2

add weeks to date in google sheets example


Step-5: Drag C2 to all cells to apply the week addition formula for other cells

Below is the final result after adding 1 week, 2 weeks, 3 weeks, 4 weeks, 5 weeks, and 6 weeks.

add weeks to date in google sheets example


As you can see above,

Cell C2 has the date that is +1 week of the date in cell A2.

Cell C3 has a date that is +2 weeks of the date in cell A3.

Cell C4 has a date that is +3 weeks of the date in cell A4.

Cell C5 has a date that is +4 weeks of the date in cell A5.

Cell C6 has a date that is +5 weeks of the date in cell A6.

Cell C7 has a date that is +6 weeks of the date in cell A7.

You can have a similar formula for removing a certain number of weeks from a date. Instead of adding now, you will be subtracting. Let’s see it in detail.


Subtract weeks from date in google sheets with example


For subtracting weeks from date in google sheets, use the below formula:

=A2-B2*7

For the same example above, now we can subtract 1 week, 2 weeks, 3 weeks, and 6 weeks from the dates in column A.


Below is the screenshot showing the example in action:

Subtract weeks from date in google sheets

As you can see from the above,

Cell C2 has a date that is -1 week from the date in cell A2.

Cell C3 has a date that is -2 weeks from the date in cell A3.

Cell C4 has a date that is -3 weeks from the date in cell A4.

Cell C5 has a date that is -6 weeks from the date in cell A5.


FAQ

How to add weeks in google sheets?

To add weeks in google sheets, use the the formula =date_cell+number_of_weeks_to_add*7

How to remove weeks in google sheets?

To remove or subtract weeks in google sheets, you can use the formula =date_cell-number_of_weeks_to_add*7

Wrapping up

In this tutorial, you learned how to add weeks to date in google sheets. Also, you saw an example of how to subtract weeks from dates in google sheets.

 Adding or subtracting weeks to dates is an important calculation while working with dates. Now go ahead and use these formulas in your worksheet. Let me know in the comments if you face any issues.


Appendix

[1] SUM formula in google sheets – Link

Further Reading

New to google sheets ? Start here

More related to Formulas:

Learn more about Google sheets Formulas.
Logical functions in google sheets
Error handling in google sheets

30+ smart tools to supercharge your sheets