How to add 7 days to a date in Excel
By
SpreadCheaters
Page last updated:
01/12/2022 |
Next review date:
01/12/2024
Excel offers a very interesting way to add 7 days to a date. We can cater to this problem statement by using the “+” operator on the keyboard. We can perform the below mentioned way to add 7 days to a date in excel:
We’ll learn about this methodology step by step.
To do this yourself, please follow the steps described below;
Step 1 – Excel workbook with a date
– Open the desired Excel workbook with date present in a cell to which 7 days can be added
Step 2 – Entering the formula
– Now in any cell type “=”, and then select the cell where the date is present, then press the “+” operator, then type “7”.
Step 3 – Hit enter to see the result
– Now hit the Enter key to get the result. We can see our result as shown in the image above.
