Forum Discussion
Query related changing the date range
Hello Everyone,
How do I change all dates in column B & C to one week earlier? 5/7/2022 to 4/30/2022 and so on all cells. Is there a quick function for that? The image above has incorrect Pay Periods - both, Start and End dates are with one week ahead in error. What I want is exact this list but a week earlier in all cells of column B & C
Please help
Date format should be mm-dd-yyyy(Month-Date-Year)
Here is a attached file
Hi Excel
You can put this formula in D2 =B2-7 as simple as this, then fill your cell down.
The second step is to copy column D and paste it as values over column B
See attached file,
4 Replies
Hi Excel
You can put this formula in D2 =B2-7 as simple as this, then fill your cell down.
The second step is to copy column D and paste it as values over column B
See attached file,
- Thank you so much sir.
- Place a 7 in a cell and copy it. Select the cells with the dates, right-click | paste special - subtract.
- Sir, can you please explain with screenshot?
Please
