Spilling Results only between certain dates

[Voski]

Hello all - I'm trying to spill the results of a horizontal dynamic spilled array. For this let's just use the example SEQUENCE(,7).
I would like to display those 7 results but only between 2 dates of a projection for construction costs. It does not work
and returns spill errors even if I use something like IF(AND(month>=startmonth,month<=end month),SEQUENCE(,7). Old school straight line results are not acceptable in this case.
The projected dates are 1-60 for 5 years; SEQUENCE(,60). Please help, thank you. I need the numbers 1-7 showing in months 4-10 without causing #SPILL errors. Note my results are not linear, they are based on a curve.

Month #

1​

2​

3​

4​

5​

6​

7​

8​

9​

10​

11​

12​

=SEQUENCE(,7)

1​

2​

3​

4​

5​

6​

7​

Start Month

4​

End Month

10​

# of Months

7​

 

[Phuoc]

Try this

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Month #	1	2	3	4	5	6	7	8	9	10	11	12
2					1	2	3	4	5	6	7
3	Start Month	4
4	End Month	10
5	# of Months	7
Sheet1

Cell Formulas
Range	Formula
B2:M2	B2	=IF(B$1 =$B3,1,IF( AND(B$1>$B3,B$1<=$B4),A2+1,""))
B5	B5	=B4-B3+1

 

[Anonymous1378]

Try this, perhaps:

Book2
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Month #	1	2	3	4	5	6	7	8	9	10	11	12
2					1	2	3	4	5	6	7
3	Start Month	4
4	End Month	10
5	# of Months	7
Sheet1

Cell Formulas
Range	Formula
B2:K2	B2	=IF(SEQUENCE(,B4,-B3+2)>0,SEQUENCE(,B4,-B3+2),"")
Dynamic array formulas.