Hi, I’m fairly new to Excel formulas, so far so good. Until now. I’m stuck on how to word a formula. It’s a working schedule, therefore I’d like the formula to tell me in cell B7 ‘Shift Error’ for example in cells B2 to B6, if there is no one on a 7:00 start, but also in cells C2 to C6 if there is no one finishing at 20:00, to display the same result in B7. Is this possible? Thanks.