N0t Y0urs
Board Regular
- Joined
- May 1, 2022
- Messages
- 96
- Office Version
- 365
- 2021
- 2019
- 2016
- 2013
- Platform
- MacOS
- Mobile
- Web
I have included the example in excel so I could use XL2BB.
If you look at the mini table I have posted it shows 5 different scenarios. Ultimately what I want is to Update "start date" C2, then if i want it to occur two times a day I would change C3 to 2 and it would adjust the dates to reflect the start date with another occurrence. As you can see I am only wanting weekdays and every 6th line has data but the date is not factored into the equation therefore it is skipped. If I need to report the date to simplify the end result it would be the same as the previous line. Example B12 would equal B11, G12 would equal F12 and so on.
Is there a way of achieving this in ideally Google Sheets or worst case Excel. The reason for not using excel is that these workings are predominately used on tablets or mobile devices which force you down the Google Path.
Thanks in advance and I hope the example helps explain what I am trying to achieve
So what I am wanting to achieve is this.
If you look at the mini table I have posted it shows 5 different scenarios. Ultimately what I want is to Update "start date" C2, then if i want it to occur two times a day I would change C3 to 2 and it would adjust the dates to reflect the start date with another occurrence. As you can see I am only wanting weekdays and every 6th line has data but the date is not factored into the equation therefore it is skipped. If I need to report the date to simplify the end result it would be the same as the previous line. Example B12 would equal B11, G12 would equal F12 and so on.
Is there a way of achieving this in ideally Google Sheets or worst case Excel. The reason for not using excel is that these workings are predominately used on tablets or mobile devices which force you down the Google Path.
Thanks in advance and I hope the example helps explain what I am trying to achieve
So what I am wanting to achieve is this.
Book1 | ||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | |||
1 | ||||||||||||||||||||||||||||
2 | Date | 3/11/24 | Date | 3/11/24 | Date | 3/11/24 | Date | 3/11/24 | Date | 3/11/24 | ||||||||||||||||||
3 | Number | 1 | Number | 2 | Number | 3 | Number | 4 | Number | 5 | ||||||||||||||||||
4 | ||||||||||||||||||||||||||||
5 | ||||||||||||||||||||||||||||
6 | Date | Level | Blah Blah | Blah Blah | Date | Level | Blah Blah | Blah Blah | Date | Level | Blah Blah | Blah Blah | Date | Level | Blah Blah | Blah Blah | Date | Level | Blah Blah | Blah Blah | ||||||||
7 | Mon 11-Mar-24 | 1 | Blah Blah | Blah Blah | Mon 11-Mar-24 | 1 | Blah Blah | Blah Blah | Mon 11-Mar-24 | 1 | Blah Blah | Blah Blah | Mon 11-Mar-24 | 1 | Blah Blah | Blah Blah | Mon 11-Mar-24 | 1 | Blah Blah | Blah Blah | ||||||||
8 | Tue 12-Mar-24 | 2 | Blah Blah | Blah Blah | Mon 11-Mar-24 | 2 | Blah Blah | Blah Blah | Mon 11-Mar-24 | 2 | Blah Blah | Blah Blah | Mon 11-Mar-24 | 2 | Blah Blah | Blah Blah | Mon 11-Mar-24 | 2 | Blah Blah | Blah Blah | ||||||||
9 | Wed 13-Mar-24 | 3 | Blah Blah | Blah Blah | Tue 12-Mar-24 | 3 | Blah Blah | Blah Blah | Mon 11-Mar-24 | 3 | Blah Blah | Blah Blah | Mon 11-Mar-24 | 3 | Blah Blah | Blah Blah | Mon 11-Mar-24 | 3 | Blah Blah | Blah Blah | ||||||||
10 | Thu 14-Mar-24 | 4 | Blah Blah | Blah Blah | Tue 12-Mar-24 | 4 | Blah Blah | Blah Blah | Tue 12-Mar-24 | 4 | Blah Blah | Blah Blah | Mon 11-Mar-24 | 4 | Blah Blah | Blah Blah | Mon 11-Mar-24 | 4 | Blah Blah | Blah Blah | ||||||||
11 | Fri 15-Mar-24 | 5 | Blah Blah | Blah Blah | Wed 13-Mar-24 | 5 | Blah Blah | Blah Blah | Tue 12-Mar-24 | 5 | Blah Blah | Blah Blah | Tue 12-Mar-24 | 5 | Blah Blah | Blah Blah | Mon 11-Mar-24 | 5 | Blah Blah | Blah Blah | ||||||||
12 | Blah Blah | Blah Blah | Blah Blah | Blah Blah | Blah Blah | Blah Blah | Blah Blah | Blah Blah | Blah Blah | Blah Blah | ||||||||||||||||||
13 | Mon 18-Mar-24 | 6 | Blah Blah | Blah Blah | Wed 13-Mar-24 | 6 | Blah Blah | Blah Blah | Tue 12-Mar-24 | 6 | Blah Blah | Blah Blah | Tue 12-Mar-24 | 6 | Blah Blah | Blah Blah | Tue 12-Mar-24 | 6 | Blah Blah | Blah Blah | ||||||||
14 | Tue 19-Mar-24 | 7 | Blah Blah | Blah Blah | Thu 14-Mar-24 | 7 | Blah Blah | Blah Blah | Wed 13-Mar-24 | 7 | Blah Blah | Blah Blah | Tue 12-Mar-24 | 7 | Blah Blah | Blah Blah | Tue 12-Mar-24 | 7 | Blah Blah | Blah Blah | ||||||||
15 | Wed 20-Mar-24 | 8 | Blah Blah | Blah Blah | Thu 14-Mar-24 | 8 | Blah Blah | Blah Blah | Wed 13-Mar-24 | 8 | Blah Blah | Blah Blah | Tue 12-Mar-24 | 8 | Blah Blah | Blah Blah | Tue 12-Mar-24 | 8 | Blah Blah | Blah Blah | ||||||||
16 | Thu 21-Mar-24 | 9 | Blah Blah | Blah Blah | Fri 15-Mar-24 | 9 | Blah Blah | Blah Blah | Wed 13-Mar-24 | 9 | Blah Blah | Blah Blah | Wed 13-Mar-24 | 9 | Blah Blah | Blah Blah | Tue 12-Mar-24 | 9 | Blah Blah | Blah Blah | ||||||||
17 | Fri 22-Mar-24 | 10 | Blah Blah | Blah Blah | Fri 15-Mar-24 | 10 | Blah Blah | Blah Blah | Thu 14-Mar-24 | 10 | Blah Blah | Blah Blah | Wed 13-Mar-24 | 10 | Blah Blah | Blah Blah | Tue 12-Mar-24 | 10 | Blah Blah | Blah Blah | ||||||||
18 | Blah Blah | Blah Blah | Blah Blah | Blah Blah | Blah Blah | Blah Blah | Blah Blah | Blah Blah | Blah Blah | Blah Blah | ||||||||||||||||||
19 | Mon 25-Mar-24 | 11 | Blah Blah | Blah Blah | Mon 18-Mar-24 | 11 | Blah Blah | Blah Blah | Thu 14-Mar-24 | 11 | Blah Blah | Blah Blah | Wed 13-Mar-24 | 11 | Blah Blah | Blah Blah | Wed 13-Mar-24 | 11 | Blah Blah | Blah Blah | ||||||||
20 | Tue 26-Mar-24 | 12 | Blah Blah | Blah Blah | Mon 18-Mar-24 | 12 | Blah Blah | Blah Blah | Thu 14-Mar-24 | 12 | Blah Blah | Blah Blah | Wed 13-Mar-24 | 12 | Blah Blah | Blah Blah | Wed 13-Mar-24 | 12 | Blah Blah | Blah Blah | ||||||||
21 | Wed 27-Mar-24 | 13 | Blah Blah | Blah Blah | Tue 19-Mar-24 | 13 | Blah Blah | Blah Blah | Fri 15-Mar-24 | 13 | Blah Blah | Blah Blah | Thu 14-Mar-24 | 13 | Blah Blah | Blah Blah | Wed 13-Mar-24 | 13 | Blah Blah | Blah Blah | ||||||||
22 | Thu 28-Mar-24 | 14 | Blah Blah | Blah Blah | Tue 19-Mar-24 | 14 | Blah Blah | Blah Blah | Fri 15-Mar-24 | 14 | Blah Blah | Blah Blah | Thu 14-Mar-24 | 14 | Blah Blah | Blah Blah | Wed 13-Mar-24 | 14 | Blah Blah | Blah Blah | ||||||||
23 | Fri 29-Mar-24 | 15 | Blah Blah | Blah Blah | Wed 20-Mar-24 | 15 | Blah Blah | Blah Blah | Fri 15-Mar-24 | 15 | Blah Blah | Blah Blah | Thu 14-Mar-24 | 15 | Blah Blah | Blah Blah | Wed 13-Mar-24 | 15 | Blah Blah | Blah Blah | ||||||||
24 | Blah Blah | Blah Blah | Blah Blah | Blah Blah | Blah Blah | Blah Blah | Blah Blah | Blah Blah | Blah Blah | Blah Blah | ||||||||||||||||||
25 | Mon 01-Apr-24 | 16 | Blah Blah | Blah Blah | Wed 20-Mar-24 | 16 | Blah Blah | Blah Blah | Mon 18-Mar-24 | 16 | Blah Blah | Blah Blah | Thu 14-Mar-24 | 16 | Blah Blah | Blah Blah | Thu 14-Mar-24 | 16 | Blah Blah | Blah Blah | ||||||||
26 | Tue 02-Apr-24 | 17 | Blah Blah | Blah Blah | Thu 21-Mar-24 | 17 | Blah Blah | Blah Blah | Mon 18-Mar-24 | 17 | Blah Blah | Blah Blah | Fri 15-Mar-24 | 17 | Blah Blah | Blah Blah | Thu 14-Mar-24 | 17 | Blah Blah | Blah Blah | ||||||||
27 | Wed 03-Apr-24 | 18 | Blah Blah | Blah Blah | Thu 21-Mar-24 | 18 | Blah Blah | Blah Blah | Mon 18-Mar-24 | 18 | Blah Blah | Blah Blah | Fri 15-Mar-24 | 18 | Blah Blah | Blah Blah | Thu 14-Mar-24 | 18 | Blah Blah | Blah Blah | ||||||||
28 | Thu 04-Apr-24 | 19 | Blah Blah | Blah Blah | Fri 22-Mar-24 | 19 | Blah Blah | Blah Blah | Tue 19-Mar-24 | 19 | Blah Blah | Blah Blah | Fri 15-Mar-24 | 19 | Blah Blah | Blah Blah | Thu 14-Mar-24 | 19 | Blah Blah | Blah Blah | ||||||||
29 | Fri 05-Apr-24 | 20 | Blah Blah | Blah Blah | Fri 22-Mar-24 | 20 | Blah Blah | Blah Blah | Tue 19-Mar-24 | 20 | Blah Blah | Blah Blah | Fri 15-Mar-24 | 20 | Blah Blah | Blah Blah | Thu 14-Mar-24 | 20 | Blah Blah | Blah Blah | ||||||||
30 | Blah Blah | Blah Blah | Blah Blah | Blah Blah | Blah Blah | Blah Blah | Blah Blah | Blah Blah | Blah Blah | Blah Blah | ||||||||||||||||||
31 | Mon 08-Apr-24 | 21 | Blah Blah | Blah Blah | Mon 25-Mar-24 | 21 | Blah Blah | Blah Blah | Tue 19-Mar-24 | 21 | Blah Blah | Blah Blah | Mon 18-Mar-24 | 21 | Blah Blah | Blah Blah | Fri 15-Mar-24 | 21 | Blah Blah | Blah Blah | ||||||||
32 | Tue 09-Apr-24 | 22 | Blah Blah | Blah Blah | Mon 25-Mar-24 | 22 | Blah Blah | Blah Blah | Wed 20-Mar-24 | 22 | Blah Blah | Blah Blah | Mon 18-Mar-24 | 22 | Blah Blah | Blah Blah | Fri 15-Mar-24 | 22 | Blah Blah | Blah Blah | ||||||||
33 | Wed 10-Apr-24 | 23 | Blah Blah | Blah Blah | Tue 26-Mar-24 | 23 | Blah Blah | Blah Blah | Wed 20-Mar-24 | 23 | Blah Blah | Blah Blah | Mon 18-Mar-24 | 23 | Blah Blah | Blah Blah | Fri 15-Mar-24 | 23 | Blah Blah | Blah Blah | ||||||||
34 | Thu 11-Apr-24 | 24 | Blah Blah | Blah Blah | Tue 26-Mar-24 | 24 | Blah Blah | Blah Blah | Wed 20-Mar-24 | 24 | Blah Blah | Blah Blah | Mon 18-Mar-24 | 24 | Blah Blah | Blah Blah | Fri 15-Mar-24 | 24 | Blah Blah | Blah Blah | ||||||||
35 | Fri 12-Apr-24 | 25 | Blah Blah | Blah Blah | Wed 27-Mar-24 | 25 | Blah Blah | Blah Blah | Thu 21-Mar-24 | 25 | Blah Blah | Blah Blah | Tue 19-Mar-24 | 25 | Blah Blah | Blah Blah | Fri 15-Mar-24 | 25 | Blah Blah | Blah Blah | ||||||||
36 | Blah Blah | Blah Blah | Blah Blah | Blah Blah | Blah Blah | Blah Blah | Blah Blah | Blah Blah | Blah Blah | Blah Blah | ||||||||||||||||||
37 | Mon 15-Apr-24 | 26 | Blah Blah | Blah Blah | Wed 27-Mar-24 | 26 | Blah Blah | Blah Blah | Thu 21-Mar-24 | 26 | Blah Blah | Blah Blah | Tue 19-Mar-24 | 26 | Blah Blah | Blah Blah | Mon 18-Mar-24 | 26 | Blah Blah | Blah Blah | ||||||||
38 | Tue 16-Apr-24 | 27 | Blah Blah | Blah Blah | Thu 28-Mar-24 | 27 | Blah Blah | Blah Blah | Fri 22-Mar-24 | 27 | Blah Blah | Blah Blah | Tue 19-Mar-24 | 27 | Blah Blah | Blah Blah | Mon 18-Mar-24 | 27 | Blah Blah | Blah Blah | ||||||||
39 | Wed 17-Apr-24 | 28 | Blah Blah | Blah Blah | Thu 28-Mar-24 | 28 | Blah Blah | Blah Blah | Fri 22-Mar-24 | 28 | Blah Blah | Blah Blah | Tue 19-Mar-24 | 28 | Blah Blah | Blah Blah | Mon 18-Mar-24 | 28 | Blah Blah | Blah Blah | ||||||||
40 | Thu 18-Apr-24 | 29 | Blah Blah | Blah Blah | Fri 29-Mar-24 | 29 | Blah Blah | Blah Blah | Fri 22-Mar-24 | 29 | Blah Blah | Blah Blah | Wed 20-Mar-24 | 29 | Blah Blah | Blah Blah | Mon 18-Mar-24 | 29 | Blah Blah | Blah Blah | ||||||||
41 | Fri 19-Apr-24 | 30 | Blah Blah | Blah Blah | Fri 29-Mar-24 | 30 | Blah Blah | Blah Blah | Mon 25-Mar-24 | 30 | Blah Blah | Blah Blah | Wed 20-Mar-24 | 30 | Blah Blah | Blah Blah | Mon 18-Mar-24 | 30 | Blah Blah | Blah Blah | ||||||||
42 | ||||||||||||||||||||||||||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B7,V7,Q7,L7,G7 | B7 | =C2 |
C7,W7,R7,M7,H7 | C7 | =1 |
B8:C11,W38:W41,R38:R39,Q40:R40,R41,L38:M38,M39:M41,G38:H38,H39,G40:H40,H41,B38:C41,W32:W35,R32:R34,Q35:R35,L32:M32,M33:M34,L35:M35,H32,G33:H33,H34,G35:H35,B32:C35,W26:W29,Q26:R26,R27:R29,M26:M27,L28:M28,M29,G26:H26,H27,G28:H28,H29,B26:C29,W20:W23,R20 | B8 | =B7+1 |
G8,G10,V38:V41,Q38,Q41,L39:L40,G39,G41,V32:V35,Q32:Q34,L33,G32,G34,V26:V29,Q27:Q29,L26:L27,L29,G27,G29,V20:V23,Q20,Q22:Q23,L20,L22:L23,G20,G22,V14:V17,Q14:Q15,Q17,L15,G15,G17,V8:V11,Q8:Q10,L8:L9,L11 | G8 | =G7 |
B13,V37,B37,Q31,G31,B31,L25,B25,G19,B19 | B13 | =B11+3 |
C13,W37,R37,M37,H37,C37,V31:W31,R31,M31,H31,C31,V25:W25,R25,M25,H25,C25,V19:W19,R19,M19,H19,C19,V13:W13,R13,M13,H13 | C13 | =C11+1 |
G13,Q37,Q39,L37,G37,L31,L34,Q25,G25,Q19,L19,Q13,L13,L16 | G13 | =G11 |
L41 | L41 | =L40+3 |