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.

Thanks again

Sorry, comments are closed for this post. If you have any further questions or comments, feel free to send them to me directly.