You can use the following basic formulas to add and subtract weeks from a date in Excel:
Formula 1: Add Weeks to Date
=A1+7*(3)
This particular formula adds 3 weeks to the date in cell A1.
Formula 2: Subtract Weeks from Date
=A1-7*(1)
This particular formula subtracts 1 week from the date in cell A1.
The following examples show how to use each formula in practice with the following dataset in Excel:
Example 1: Add Weeks to Date in Excel
We can type the following formula into cell C2 to add 3 weeks to the date in cell A2:
=A2+7*(3)
We can then drag and fill this formula down to each remaining cell in column C:
Column C now displays the date in column A with exactly 3 weeks added to it.
Feel free to change the 3 in the formula to any value you’d like to add a different number of weeks to the original date.
Example 2: Subtract Weeks from Date in Excel
We can type the following formula into cell C2 to subtract 1 week from the date in cell A2:
=A2-7*(1)
We can then drag and fill this formula down to each remaining cell in column C:
Column C now displays the date in column A with 1 week subtracted from it.
Feel free to change the 1 in the formula to any value you’d like to subtract a different number of weeks from the original date.
Additional Resources
The following tutorials explain how to perform other common tasks in Excel:
How to Group Data by Week in Excel
How to Sum by Week in Excel