How do I check for duplicates within several columns and check a box
I'm making a grid for staffing events. Basically each event can have up to 3 staff members. I want a formula that will check for if there are multiple events on the same date and if a staff member is accidentally double booked. If they are double booked, to check the checkbox so I can run some conditional formatting. I've attached an example spreadsheet below.
What would my formula look like to check the "Double Booked" box?