Repeat a cell value each month

[JBDIFA]

I'm trying to build a budget ongoing cash flow, so I have an amount going out each month on a particular day. I would like to put in the amount and for that to repeat on the 3rd of each month.

My cells on the left have Provider-Amount-repeat day, Accpros the top I have the date.

Any help would be appreciated.

	06/08/2024	07/08/2024
Day in Month	Tuesday
Balance	-£4.79
	ü
Gym	£10.00	3

[#2]

@JBDIFA 

You have had close to 50 views without a reply. I suspect that may be due to the fact that your example is hard to make sense of. For example:

• Day in Month: Tuesday? There are typically several Tuesdays in any given month, not just one. What are we to make of that entry?
• What is the ü in the row under the "balance"?
• What does the 3 in the final cell represent?

Do you have a more complete spreadsheet started yet? Could you share it on OneDrive, GoogleDrive or some equivalent? Just give us a link here that grants access. My suspicion is that there may be a better design that would help, but we need to see where you're going with more sample entries.

[#3]

Sorry, Day in Month: Tuesday? There are typically several Tuesdays in any given month, not just one. I need the day to be taken from the date in the above cell.
The day What are we to make of that entry? The day "Tuesday" is just for my use.
What is the ü in the row under the "balance"? On my Spreadsheet it is a tick symbol.
What does the 3 in the final cell represent? 3 is the day that the debit is collected each month.
I'm sorry my explanation was so poor.

[#4]

@JBDIFA 

OK. You a;nswered my questions. I also had a request.

Do you have a more complete spreadsheet started yet? Could you share it on OneDrive, GoogleDrive or some equivalent? Just give us a link here that grants access. My suspicion is that there may be a better design that would help, but we need to see where you're going with more sample entries.