Google Sheets Query - Date Driven Formula

[N0t Y0urs]

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.

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

 

[N0t Y0urs]

marking this is closed

 

[Peter_SSs]

marking this is closed

FYI: The mark at the right of posts is to mark the solution not a closure so I have removed the mark from post 2.