Automatic Update of Month

Hi there,

I have a spreadsheet where I have listed out the months and Monday "day numbers" for the next two years. We are going to be updating this chart monthly. Is there any way for Excel to automatically delete the previous month and add a month automatically?

Thanks in advance.

I have attached a mock file for reference.

Thank you so much.

Just wondering, which part of the code do I change so that it only does 30 months ahead?

Thanks again.