no, in the other thread its to do with shading, this one is for dates. Ive sorted the problem in the other thread.

Ill try and put this thread question easier. In the spreadsheet i attached, ive now set the CF in the boxes to shade automatically when it passes a certain time. the problem im having now is that the times on the top row, from 08:00 all the way to 07:00, need changed to fit the same day as the dates on the left in the sign in and out boxes. so if that rota is for, say, 20th march 2014, the left hand boxes would be updated by the user, all to the 20th march, but the top row is set to the same date, so when you update the dates on the left, the boxes do not highlight anymore as the formula states otherwise.