How to Add or Subtract Weeks to Date
Nov 11, 2016
1 min read
If you want to add or subtract whole weeks to a certain date, you can use the same formulas as for adding / subtracting days, and simply multiply the number of weeks by 7:
Adding weeks to a date in Excel:
=A2 + N weeks * 7
For example, you add 3 weeks to the date in A2, use the following formula: =A2+3*7.
Subtracting weeks from date in Excel:
=A2 - N weeks * 7
To subtract 2 weeks from today's date, you write =TODAY()-2*7.
Comments