Hello,

I have the below formula, that spills out forecasted transactions based on frequency. I'm struggling to find an insert for the Weekly and monthly switch cases, that increase from a sequence start point.

=ArrayFormula(QUERY(SPLIT(HLOOKUP(INT(SEQUENCE(COUNTA(A7:A)*365,1,C3*COUNTA(A7:A))/COUNTA(A7:A)),

{SEQUENCE(1,365,C3);

IF(SWITCH(IF(SEQUENCE(1,365),A7:A),
"Annually",SEQUENCE(1,365,C3)=DATE(F7:F,D7:D,E7:E),
"Once-Off", SEQUENCE(1,365, C3)=DATE(F7:F,D7:D,E7:E),
"Weekly", SEQUENCE(1,365,C3) = E7:E,
),
G7:G&"|"&H7:H&TEXT(SEQUENCE(1,365,C3),"|d/m/yyy|")&I7:I,
)},

MOD(SEQUENCE(COUNTA(A7:A)*365,1,0),COUNTA(A7:A)+2,),"|"),

"where year(Col3) >= "&YEAR(C3)&" order by Col3",0)))