Forum Discussion

Excel's avatar
Excel
Iron Contributor
May 30, 2022
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...
excel
Formulas and Functions
  • Jihad Al-Jarady's avatar
    Jihad Al-Jarady
    May 30, 2022

    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,

Patrick2788's avatar
Patrick2788
Silver Contributor
May 30, 2022
Place a 7 in a cell and copy it. Select the cells with the dates, right-click | paste special - subtract.
Excel's avatar
Excel
Iron Contributor
May 30, 2022
Sir, can you please explain with screenshot?
Please

Resources