Exccel - date formula that drives multiple other formulas

[N0t Y0urs]

I have included the example in excel so I could use XL2BB. - I originally posted this in GSheets as this is where I would ideally like to work from but since it got not responses I thought I will come back to excel and find out if its possible in excel and then fumble my way with the work around in GSheets.

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
Sheet1
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

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]

Sorry I missed this maybe simpler explanation.

As a previous, MOUS things have changed a little but the functionality of what I want now wasn't available back then. In short, what I think I need to do now is use XLOOKUP along with IF/S and the WEEKDAY option.

This is what I am wanting to do: Basically start with a Monday (therefore the weekday formula) in its simplest form. Each new line is a new day representing a Mon - Friday. The 6th line represents my totals. However, this is where it now gets harder. Say I want to recur every weekday 3 times I was thinking it needs to reference the lookup so in effect my first 5 lines are Mon, Mon, Mon, Tues, Tues the 6th line being totals and the 7th being the 3rd reference to Tues, Wed, Wed, Wed, Thurs and then totals etc.

 

[Fluff]

Duplicate to: Google Sheets Query - Date Driven Formula

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.