Can you post an amended workbook where you put your desired results in manually for a couple of the weeks, I am not absolutely sure what you are asking?
Also, shouldn't you be using conditional formatting for that colouring in I6:R55, I assume you do it manually now.
Bookmarks