Detecting in covered shift.

New Contributor
Hi everyone

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
2 Replies

@Jnewman93 You can upload a picture by clicking on the camera symbol and following the instructions.

Screenshot 2021-12-19 at 07.59.39.png

I see the issue I’m using an iPhone so the option is not there. I will use my laptop to reply.

Thanks You