Table of Contents
To add or subtract weeks to a date in Excel, follow these steps:
1. Select the cell where you want the new date to appear.
2. Type in the original date in the desired format (e.g. 1/1/2021 or January 1, 2021).
3. After the date, type a plus sign (+) to add weeks or a minus sign (-) to subtract weeks.
4. Type the number of weeks you want to add or subtract.
5. Press Enter to calculate the new date.
This method allows you to easily manipulate dates in Excel and can be useful for project planning, budgeting, and other tasks that require date calculations.
Add & Subtract Weeks to Date in Excel
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
=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.
The following tutorials explain how to perform other common tasks in Excel:
Cite this article
stats writer (2024). How do I add or subtract weeks to a date in Excel?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-do-i-add-or-subtract-weeks-to-a-date-in-excel/
stats writer. "How do I add or subtract weeks to a date in Excel?." PSYCHOLOGICAL SCALES, 27 Jun. 2024, https://scales.arabpsychology.com/stats/how-do-i-add-or-subtract-weeks-to-a-date-in-excel/.
stats writer. "How do I add or subtract weeks to a date in Excel?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-do-i-add-or-subtract-weeks-to-a-date-in-excel/.
stats writer (2024) 'How do I add or subtract weeks to a date in Excel?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-do-i-add-or-subtract-weeks-to-a-date-in-excel/.
[1] stats writer, "How do I add or subtract weeks to a date in Excel?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How do I add or subtract weeks to a date in Excel?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.