I have also added a columns to indicate the weekends.
Under the days I have the date, indicated by a single or double digit.
Under that for the whole week ie 5 days I would like to add the shift we are on for that week. And for it to change automatically when I update the spreadsheet each year.
I am not sure how I can use the WEEKDAY function for this.