Billing Amount calculation based on billing frequencies

The attached file has billing amounts from column G onwards. these billing amounts are calculated based on the subscription's start date and end date in column C and D and billing frequency in column F. I am unable to update my formula for semiannual billing. Can someone suggest help fix that

Try this, G2=IF(IFERROR(IF($D2<EDATE(G$1,1),NA(),MOD(DATEDIF(DATE(YEAR($C2),MONTH($C2),1),G$1,"m"),LOOKUP($F2,{"Annual","Monthly","Quarterly","Semiannual"},{12,1,3,2})))=0,FALSE()),$B2/MIN(LOOKUP($F2,{"Annual","Monthly","Quarterly","Semiannual"},{1,12,4,2}),DATEDIF($C2,$D2+1,"m")),0), copy across and down.

Thanks, Josephteh. This worked. Super Thankful to you!

Try this: I2=IF(IFERROR(IF($D2<EDATE(I$1,1),NA(),MOD(DATEDIF(DATE(YEAR($C2),MONTH($C2),1),I$1,"m"),LOOKUP($F2,{"Annual","Monthly","Quarterly","Semiannual"},{12,1,3,6})))=0,FALSE()),$B2,0)/IF($F2="Monthly",MAX(LOOKUP($F2,{"Annual","Monthly","Quarterly","Semiannual"},{1,12,4,2}),DATEDIF($C2,$D2+1,"m")),MIN(LOOKUP($F2,{"Annual","Monthly","Quarterly","Semiannual"},{1,12,4,2}),DATEDIF($C2,$D2+1,"m")))