Jul 22 2022
My current issue using excel as a rookie is i need to group the dates from monday to sunday and use formulas on another sheet to calucate a whole heap of information.
But when i drag formulas it obviously makes it sequential which messes with my data.
how can i lock in 11/07/22 to 17/07/22 then pull my formula down and it locks in the next 18/07/22 to 24/07/22 without manualing changing the formulas selected cells.
Jul 23 2022