Formula to Fill in Cells from Start month to an ending month

Hey guys,

Would be great if you could help.

Im trying to create a table where i can forecast my client retainers.

I basically want to the function to read from a a cell with a retiner amount, the month it will start, and the month it will end.

So if the retainer is 100/month, starts in Jan 2023 and ends in June 2023 I want it the months to be filled With jan and june included with all inbetween.

Ive attached a file to help showcase.

Regards,
M.

Is this what you are after?

In cell K20 (drag across and then down)

=IF(AND(K$19>=$I20,K$19<=$J20),$E20,"")

Thats perfect.

The issue was it wouldnt include the closing month for some reason.

Thank you Croweater!

You're welcome.