How to generate list of start dates

[ac7]

Hello -

I am struggling with a formula and am hoping someone can provide some suggestions on how to accomplish what I need. In the month of March, I have 19 available working days (M-F only). With 8 hours a day, that gives me 152 hours available in the month. My shift starts at 6:00 and ends at 14:00. I have 13 jobs that need to be started in the month of March, beginning March 4th. I can only start these on a Monday through Friday. The approximate time between each job is 11.69 hours.

Working Days	19​
Working Hours	152​
Start of Day	6:00​
End of Day	14:00​
Starts	13​
Hours between starts	11.69​
Starting Date	3/4/2024​

I need to produce a list of dates to show what days I will be starting the jobs. Does anyone have suggestions on how I can best do this?

Thank you in advance!

 

[JamesCanale]

This does the trick I think, but it's clumsy. The workday function doesn't take arrays for inputs.

MrExcelPlayground21.xlsx
	B	C	D	E	F	G	H
1							Holidays
2	Monday, March 4, 2024						Tuesday, March 19, 2024
3	Sunday, March 31, 2024	19					Monday, May 27, 2024
4	Starts	13
5	Start	6:00
6	End	14:00
7	Hours	152
8	Hours between starts	11.69230769
9
10		0	Monday, March 4, 2024
11		1.461538462	Tuesday, March 5, 2024
12		2.923076923	Wednesday, March 6, 2024
13		4.384615385	Friday, March 8, 2024
14		5.846153846	Monday, March 11, 2024
15		7.307692308	Wednesday, March 13, 2024
16		8.769230769	Thursday, March 14, 2024
17		10.23076923	Monday, March 18, 2024
18		11.69230769	Wednesday, March 20, 2024
19		13.15384615	Friday, March 22, 2024
20		14.61538462	Monday, March 25, 2024
21		16.07692308	Wednesday, March 27, 2024
22		17.53846154	Thursday, March 28, 2024
Sheet2

Cell Formulas
Range	Formula
B3	B3	=EOMONTH(B2,0)
C3	C3	=NETWORKDAYS.INTL(B2,B3,1,H2:H13)
C7	C7	=C3*(C6-C5)*24
C8	C8	=C7/C4
C10:C22	C10	=SEQUENCE(C4,1,0,(C8/24)*(1/(C6-C5)))
D10:D22	D10	=WORKDAY.INTL($B$2,C10,1,$H$2:$H$3)
Dynamic array formulas.