Auto assign a list of names to dates of the month

[ogwt]

Hello Everyone
I have a list of days and months as shown below through to December 2022 and I am looking for a way to auto add the list of names (which can change) automatically in the name column against a date.
As shown, when the names get to the end of the dates, they restart in the next name column?

Any thoughts

Regards
I have a list of

 

[Skybluekid]

Can you list the months in columns, ie A for Name, B for Date. If so, then using a straight lookup will do the job.

 

[ogwt]

Can you list the months in columns, ie A for Name, B for Date. If so, then using a straight lookup will do the job.

Not sure, but I can try
Thank for your response. I will feedback if I need more help