[Additional Question]Formulas for assign monthly values to correspond weeks

[jackson_hollon]

Hello,
I have a worksheet that requires 3 formulas.
In row 1, I have the monthly set up. In row 11, I have the weekly set up while Monday is being the first day of the week.

Formula #1 for rent:
In row 3, I have the rent payments; each is due on the first day of the month.
I need a formula in row 13 that will put the monthly rent payment (row #3) to correspond week (first day of the month)

Formula #2 for Insurance:
In row 4, I have the Insurance payments; each is due on the last day of the month.
I need a formula in row 19 that will put the monthly insurance payment (row #4) to correspond week (last day of the month)

Formula #3 for Bank Interest:
In row 5, I have the Bank Interest payments; each is due on the 19th of each month.
I need a formula in row 25 that will put the monthly interest payment (row #5) to correspond week (19th of each month)

Monthly Payement.xlsx
I hope I have made myself clear.
Thanks in advance for all of your great help.

[popipipo]

Take a look at this

[jackson_hollon]

popipipo


This is exactly what I am looking for. Thank you very much for the help.

[jackson_hollon]

popipipo,

I am a little bit confused. When I used your formula =IF(AND(DAY(E11)<=19,DAY(F11)>19),HLOOKUP(EOMONTH(E11,-1)+1,$B$1:$N$5,5,0),""), it works perfectly for 19th. But if I changed the formula for 25th day to =IF(AND(DAY(E11)<=25,DAY(F11)>25),HLOOKUP(EOMONTH(E11,-1)+1,$B$1:$N$5,5,0),""), it will skip Feb and May payments. what is the logic Behinds that?

Sorry for asking. Below I have attached the file.

Monthly Payement_2-2.xlsx

Thanks for the help.

[popipipo]

This is because there is no datevalues in february and may greater then 25

[jackson_hollon]

popipipo

Thanks for the reply. In this case, do you mind to show me how I can modify the formula so that I can use it for the 25th day?

Thanks in advance for your great help.

[popipipo]

Sorry but I don't have a solution for that