Forum Discussion
Solved
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 Pe...
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,
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.
