I am trying to keep a tally of shifts in an excel staff roster. I’m having trouble finding a formula that works (just a novice user). Basically we want to be able to keep a tally of the following:
– How many saturdays the staff member has worked (7am or 3pm)
– How many sundays the staff member has worked (7am or 3pm)
– How many public holidays have they worked
All Sat and Sun shifts are filled with orange and all public holidays are filled with blue. I thought I could use this colour system somehow, but no luck so far. I’ve attached an example of what the roster does look like.