Calendar Automatic Day of Week Problem

Hi all,

That is probably the worst short title EVER, but it difficult to explain in half a dozen words!!

I have attached a simple calendar which even though it says "2021" in the top left, the days of the week that correspond to the date are from 2020. Rather than me having to go in and change each day of the week, is there a formula that I can put into the cells so that when I change the year, the days of the week automatically change to the correct day for that year?

Thanks in advance.
Glenn

That is awesome! Thank you so much.

I see that you didn't account for leap day (29th February) in your 2020 list. Do you want an amendment for that?

Pete

Originally Posted by Pete_UK

I see that you didn't account for leap day (29th February) in your 2020 list. Do you want an amendment for that?

Pete

No thanks mate. It was copied from my 2020 calendar and then the 29th removed for 2021. The days of the week remained for 2020, with the new formula now added.
Thanks