Need Formula to post payments with different dates frequency than Column Headers

Hi
I have columns divided in Fortnightly dates ranges with start date and end dates as headings.

I have different payments as follows;
1- Some Paid every 7 days
2- Some Paid every 14 days
3- Some Paid on 2nd of each month
4- Some Paid on 2nd of every consecutive month
5- Some Paid on 2nd of every 3rd (Quarterly) month

WHAT I HAVE DONE SO FAR?
For each of above 5 categories, I have done a different formula to put payments in relevant Fortnightly Columns, so the payments appear in proper dates ranges. For example 7days payment appears twice in each column and so on..
My formulas(though not very well written) worked for 7day, 14day and monthly payments.
But it did not work for bi-monthly payments.
and for quarterly payments, I can't think of a way.


WHAT IS NEEDED
1- I have written formulas not so good and complex, is there some simpler alternative?
2- My formula did not work for bi-monthly payments. The payments are appearing every month instead of every 2nd month. What is issue in it?
3- I can't even think of a formula to get quarterly payments on columns as it will get more complex with my procedure. Can there be some solution for quarterly payemnts?

Hope I am able to explain my issue.

An Important Thing My Columns Date range in this example is 14 days but it is not fixed so I need a solution that can work with any Column Date range like a week, fortnight, month, quarter, year etc.

There are instructions at the top of the page telling you how to attach your sample workbook. Make sure the sample is less than 1MB.

File now attached. Thanks

Please try at C7

=IF(MATCH($B7,$C$4:$L$4)<=COLUMNS($C7:C7),IFNA($B$1*MATCH($A7,{"Bi-Weekly","Weekly"},),$B$1*OR(INDEX(ABS(EDATE($B7,{0;1;2;3;4;5;6;7;8}*MATCH($A7,{"Monthly","Bi Monthly","Quarterly"},))-(C$4+7))<=7,))),0)

@Bo_Ry
Sorry I forgot to mention that my columns are not fixed for 14 days ranges. These keep changing to other periods like 7 days, 14days, month, quarter, year etc.

How can your formula work for a dynamic column date range?

Please try at C7

=IF(MATCH($B7,$C$4:$L$4)<=COLUMNS($C7:C7),IFNA(SUMPRODUCT(--(ABS($B7+(MATCH($A7,{"Weekly","Bi-Weekly"},)*7)*(ROW($A$1:$A$99)-1)-AVERAGE(C$4:C$5))<=(C$5-C$4)/2))*$B$1,$B$1*OR(INDEX(ABS(EDATE($B7,(ROW($A$1:$A$50)-1)*MATCH($A7,{"Monthly","Bi Monthly","Quarterly"},))-(C$4+7))<=7,))),0)

This cover 99 weeks and 50 Months, you may increase the number in red to cover more time

Hi Bo_Ry

THIS TIME YOU HAVE CREATED SOME CRAZY STUFF THAT I HAVE NEVER SEEN BEFORE

AND IT WORKS!!!

I thought there was issue. Actually that was my misunderstanding about the Magic of "ROW($A$1:$A$99)" thing.
I really don't understand how you did this
"ROW($A$1:$A$99)" given an answer of 1 but when we put 1 in formula, it doesn't work.

I really want to learn how this thing worked. Can you please suggest me some tutorial about this thing?

Again super thanks for help

=IFNA(SUMPRODUCT(--(ABS($B13+(MATCH($A13,{"Weekly","Bi-Weekly"},)*7)*(ROW($A$1:$A$99)-1)-AVERAGE(C$10:C$11))<=(C$11-C$10)/2))*$B$7,$B$7*OR(INDEX(ABS(EDATE($B13,(ROW($A$1:$A$50)-1)*MATCH($A13,{"Monthly","Bi Monthly","Quarterly"},))-(C$10+7))<=7,)))

Row(a$1:A$99) return array of {1;2;3;…99}

Row(a$5:A$99 return array of {5;6;7;…99} it will miss the first 4 weeks date