SOLVED Cash Flow Chart From Period and monthly payment

Ive searched the and have joined this forum in hopes of finding an answer.
Given a period, a "from date" and a "to date" and a monthly payment amount, how can I get Excel to put that value into all of the months in the "from" and "to"??

For example: from 1 Jan 2024 to 30 Jun 2024, monthly payment is $1000.00

I would like it look something like:

from to monthly Payment: Jan Feb Mar Apr May Jun Jul Aug
1/1/24 30/6/24 $1000 $1000 $1000 $1000 $1000 $1000 $1000

Where it fills the monthly in from the payment amount and date range.

Thanks.

BC