Forum Discussion
Solved
Count only Scheduled Employee's
I have a spread sheet of employee's and schedules. I need to be able to see how many are scheduled today, vs how many actually showed. Currently i'm using =COUNTIFS('Active Associates'!$G:$G,"1...
I think we're on the right path and i'm just having trouble putting all the pieces together.
The issue i'm having now is only counting the people scheduled for "Today" as indicated by the Day code in Q4
I've attached your previous file with different attempts at getting this to work.
Here's where i'm currently stuck at.
I've highlighted the cells in yellow. I'm trying to show that on Tuesday (Today) that I should have 4 people on site. The rest of the day's should be blank or "0" because it's not Tuesday.
I've got the date, and a Day code up top to help but i'm just not able to calculate it correctly.