Detecting in covered shift.

[Jnewman93]

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]

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

[#3]

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

Thanks You