Hi,
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.
| 11/07/2022 | 28 | 24 | 7 | 9 | 8 | |
| 12/07/2022 | 49 | 46 | 18 | 20 | 8 | |
| 13/07/2022 | 30 | 29 | 8 | 15 | 6 | |
| 14/07/2022 | 33 | 32 | 9 | 13 | 10 | |
| 15/07/2022 | 45 | 42 | 17 | 16 | 9 | |
| 16/07/2022 | | | | | | |
| 17/07/2022 | | | | | | |
| 18/07/2022 | 38 | 34 | 10 | 19 | 5 | |
| 19/07/2022 | 33 | 30 | 6 | 14 | 10 | |
| 20/07/2022 | 50 | 42 | 23 | 15 | 4 | |
| 21/07/2022 | 44 | 39 | 16 | 15 | 8 | |
| 22/07/2022 | 42 | 38 | 20 | 10 | 8 | |
| 23/07/2022 | | | | | | |
| 24/07/2022 | | | | | | |
