Next payment date

[MEC]

Hi,

I have the below spreadsheet formula

=WORKDAY(sum(IFS(N29=“Daily”,IF(WEEKDAY(Q29,2)=5,Q29+3,Q29+1),N29=“Weekly”,Q29+7,N29=“Trimonthly”,Q29+10,N29=“Bimonthly”,Q29+14,N29=“Monthly”,IFERROR(IF(EDATE(Q29,1)=index(Holidays!B:B,match(EDATE(Q29,1),Holidays!B:B,0)),EDATE(Q29,1)+1,EDATE(Q29,1)),EDATE(Q29,1))),-1),1,filter(Holidays!$B$2:$B1028,Holidays!$B$2:$B1028<>""))

Basically, what it does is, it returns the starting payment date of a loan based on the loan’s payment interval. The below is an example.

My problem is, i have to drag down the formula manually coz appsheet returns an error like the last row in the photo. Any help would be appreciated!

Thanks.