How could I get excel to detect when a shift is not covered, automatically? And as a bonus determine if it is a day or night that is not covered. Ideally it would appear at the bottom of each table column which represents 1 day of the week. I have a screen shot of the table if I’m able to upload it? Thanks and Merry Christmas