I’m a train driver and working a 33-week link, starting Sunday to Saturday.
After the first week the date F1 must change, with it the names in B3 and C3 must move one row down to B4 and C4 and the rest of the names.
From D to J must remain the same. Only week 1 B3 and C3 names must move down weekly, as the date changes, so will B3 and C3
The last week 33 the names in B35 and C35 must move up to week 1 B3 and C3.
Formula not working =IF(A1=1,15,A1-1)
I would appreciate it If you could help me with a formula for both names B3 and C3 to rotate, and a formula for when the date F1 changes weekly.
After the first week the date F1 must change, with it the names in B3 and C3 must move one row down to B4 and C4 and the rest of the names.
From D to J must remain the same. Only week 1 B3 and C3 names must move down weekly, as the date changes, so will B3 and C3
The last week 33 the names in B35 and C35 must move up to week 1 B3 and C3.
Formula not working =IF(A1=1,15,A1-1)
I would appreciate it If you could help me with a formula for both names B3 and C3 to rotate, and a formula for when the date F1 changes weekly.
COMPLEX LINK | 24 SEPTEMBER - 31 SEPTEMBER 2023 | ||||||||||||||||
W | T / DRIVER | TRAIN ASSISTANT | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | ||||||||
1 | Jan | Tom | WEEKEND | WEEKEND | 3501 06:00 | 5500 06:00 | 2000 06:00 | 8002 18:00 | 5505 18:00 | ||||||||
2 | Hans | JP | 7200 18:00 | 5501 18:00 | R / D | R / D | SIMP | 5508 06:00 | 5500 06:00 | ||||||||
3 | Gerrie | Max | 3501 06:00 | 5504 06:00 | 5503 18:00 | 5509 18:00 | 2001 18:00 | WEEKEND | WEEKEND | ||||||||
4 | Van | Dean | WEEKEND | WEEKEND | 5512 06:00 | 3501 06:00 | 5500 06:00 | 2001 18:00 | 5503 18:00 | ||||||||
5 | Sid | Flip | 3601 18:00 | 5513 18:00 | R / D | R / D | SIMP | 5500 06:00 | 5508 06:00 | ||||||||
COMPLEX LINK | 1 October - 6 October 2023 | The formula will change the date F1 to date in F10 after a week | |||||||||||||||
W | T / DRIVER | TRAIN ASSISTANT | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | with it B3 and C3 move down to B4 and C4. | |||||||
1 | Sid | Flip | WEEKEND | WEEKEND | 3501 06:00 | 5500 06:00 | 2000 06:00 | 8002 18:00 | 5505 18:00 | ||||||||
2 | Jan | Tom | 7200 18:00 | 5501 18:00 | R / D | R / D | SIMP | 5508 06:00 | 5500 06:00 | ||||||||
3 | Hans | JP | 3501 06:00 | 5504 06:00 | 5503 18:00 | 5509 18:00 | 2001 18:00 | WEEKEND | WEEKEND | ||||||||
4 | Gerrie | Max | WEEKEND | WEEKEND | 5512 06:00 | 3501 06:00 | 5500 06:00 | 2001 18:00 | 5503 18:00 | ||||||||
5 | Van | Dean | 3601 18:00 | 5513 18:00 | R / D | R / D | SIMP | 5500 06:00 | 5508 06:00 |