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:
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:
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
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
Step-4: Press enter and you will have 1 week added to A2
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.
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:
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
