To add or subtract a date from Excel, there is a simple arithmetic method that you can use. But, apart from that, there are a few more ways that you can use. In this tutorial, we will look at all those ways one by one.
Add a Week in a Date
In the following example, you have a date in cell A1 and now you need to add a week into the date.
- First, enter “=” in cell B1.
- Next, refer to the cell where you have the date.
- Now, enter “+” to addition.
- In the end, enter 7 to add a single week to the date.
As you can see, after adding seven days to the data you got 8th Dec which is exactly one week after 1st Dec. Now if you want to want to add more than one week to a date you can multiple the 7 with that number.
In the above example, you have multiplied (7*3) to add the 21 days which is equal to 3 weeks.
Subtract Week from a Data
By the using exact same method, you can also subtract a week or multiple weeks from a date. You need to use the subtract instead of addition.
And if you want to subtract more than one week from a date you can multiply 7 with that number.
Other Methods (SUM function)
There is one more method that you can use to add or subtract week(s) from a date. Instead of using an add or subtract operator, you can use the sum function.
In the following example, you have the sum function where the first argument is the date and in the second argument, we have 7 to add a week to the date.
And this is for multiple weeks.
- Add Month to a Date
- Add Years to Date
- Calculate Age using Date of Birth
- Compare Two Dates
- Convert Date to Number
- Count Years Between Two Dates
- Create a Date Range
- DATEDIF Function in Excel
- Get Day Number of Year
- Get Month from a Date
- Get Quarter from a Date [Fiscal + Calendar]
- Get Years of Service
- Get Day Name from a Date in Excel
- Get End of the Month Date in Excel
- Get Total Days in Month in Excel
- Highlight Dates Between Two Dates
- Quickly Concatenate Two Dates
- Random Date Generator (Excel Formula)
- 5 Custom Date Formats I Always Use and You Should Too
- Convert Text to Date
- Get First Day (Beginning) of the Month