Problem with Dates in Excel (scheduling a day in a week each month)

[financefinance]

In cell B10 I have a value of $10,000
In cell C10, I have the value 26
In this example, I am intending to create a schedule of payments in whichever week the 26th falls in each month throughout the year

In cell D6 I have the week ending date 12/25/2020
In cell E6 I have the week ending date 1/1/2021 (in this example, I am expecting the payment to be in the week in 1/1/21)
In cell F6 I have the week ending date 1/8/2021 ... and so on

I tried the following formulas, but neither is resulting a value in the week of 1/1/2021 (I understand why I am not getting the value; I am not sure of the fix)
=IF(AND($C10>(DAY(D$6)-7),$C10<=DAY(D$6)),$B10,0)

=IF(AND(DATE(YEAR(D$6),MONTH(D$6),$C10)>(D$6-7),DATE(YEAR(D$6),MONTH(D$6),$C10)<=D$6),$B10,0)

Prefer a formula solution. Appreciate your help!

 

[Fluff]

Did you try the formula that Jason suggested in post#5, just replacing the reference to B10 with your sumproduct formula?

 

[jasonb75]

Not sure if I'm following correctly given the frequent brainfarts that I've been having lately but this is my attempt at what I think is needed. The hidden columns all have blanks returned by the formulas, I've just done this so that the table fits the forum a bit easier.

Book1
	B	C	D	E	F	G	H	I	J	K		M				Q					V				Z					AE	AF
5			25/12/2020	01/01/2021	08/01/2021	15/01/2021	22/01/2021	29/01/2021	05/02/2021	12/02/2021		26/02/2021				26/03/2021					30/04/2021				28/05/2021					02/07/2021	09/07/2021
6	P	26		1500000				0				0				1400000					0				1400000					0
7	I	26		25000				0				0				28000					0				0					19000
8	F	26		8000				0				0				15500					0				0					16000
9
10			30/11/2020	31/12/2020	31/01/2021	28/02/2021	31/03/2021	30/04/2021	31/05/2021	30/06/2021
11	P		00/01/1900	1500000	0	0	1400000	0	1400000	0
12	I		00/01/1900	25000	0	0	28000	0	0	19000
13	F		00/01/1900	8000	0	0	15500	0	0	16000
Sheet3

Cell Formulas
Range	Formula
D6,F6:H6,J6:K6,AF6,AE6:AE8,Z6:Z8,V6:V8,Q6:Q8,M6:M8,I6:I8,E6:E8	D6	=FILTER($D$11:$K$13,OR(DAY(D$5-{0,1,2,3,4,5,6})=$C6)*($D$10:$K$10=EOMONTH(D$5+6,-1)),"")