I am about to lose my mind! Please help . I am building a rotation schedule and would like to be prompted with a Yes or No is someone has a day off within a week. This is what I am trying but the result I am getting is #VALUE!. Below is a snapshot of what I've started. The second snapshot is from the worksheet I am pulling from ('DaysOff'). The range for the Days Off worksheet is A3:Q801.

Formula Snapshot.PNG

Days Off Snapshot.PNG

Thank you!!