Dynamic formula based on start date and duration

[BMil8]

Hello. I'm looking for a formula to help with product build rollout. I have a table showing different waves, start dates, wave duration, and product count. I want the daily build table to populate accordingly based on the inputs at the top. The below is a general example. If I change any of the fields above, I'd like the table to update. All days assume an equal build count. The non build days should just show zero. Sorry if I'm not explaining it coherently. ("Wave#" = A1)

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D
1
2		28/08/2023	01/09/2023	04/09/2023
3		4	5	6
4		1000	1200	3000
5	27/08/2023	0	0	0
6	28/08/2023	250	0	0
7	29/08/2023	250	0	0
8	30/08/2023	250	0	0
9	31/08/2023	250	0	0
10	01/09/2023	0	240	0
11	02/09/2023	0	240	0
12	03/09/2023	0	240	0
13	04/09/2023	0	240	500
14	05/09/2023	0	240	500
15	06/09/2023	0	0	500
16	07/09/2023	0	0	500
17	08/09/2023	0	0	500
18	09/09/2023	0	0	500
19	10/09/2023	0	0	0
Master

Cell Formulas
Range	Formula
B5:D19	B5	=IF(($A$5:$A$19>=B2)*($A$5:$A$19<B2+B3),B4/B3,0)
Dynamic array formulas.

 

[BMil8]

Thank you, that seems to do the trick. These Spill formulas always seem to confuse me but it's doing what I want. Thank you!

 

[Fluff]

You're welcome & thanks for the feedback.