Auto update date to match days??

[squirrellydw]

The pic below show a spreadsheet I'm working on. Top left in A1 is the current YEAR. In the calendar layout below I would like to have the day number show up in the top row of each month and to go under the correct day that is listed. For example today is Sunday March 2nd so I would like it to show up in the top row of March under Sunday. Then when the year 2026 comes along change the year at the top and have all the dates move correctly. How can I do this?

 

[squirrellydw]

That's what I want

EDIT...I got it working just how I wanted, thank you

Thank you so much, this is perfect!!