Hello,
I would appreciate someone's help. I have a rota set out like the one below and I'm wondering if the is any variation of a count formula which would be able to allow me to count the number of weekend days each individual staff member has worked?
I would appreciate someone's help. I have a rota set out like the one below and I'm wondering if the is any variation of a count formula which would be able to allow me to count the number of weekend days each individual staff member has worked?
bob.xlsx | |||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | |||
8 | Example Results | ||||||||||||||||||||
9 | SATURDAYS WORKED | SUNDAYS WORKED | |||||||||||||||||||
10 | BOB | 2 | 1 | ||||||||||||||||||
11 | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | TIM | 0 | 1 | ||||
12 | 28/04/2021 | 29/04/2021 | 30/04/2021 | 01/05/2021 | 02/05/2021 | 03/05/2021 | 04/05/2021 | 05/05/2021 | 06/05/2021 | 07/05/2021 | 08/05/2021 | 09/05/2021 | 10/05/2021 | 11/05/2021 | |||||||
13 | |||||||||||||||||||||
14 | BOB | 9am - 5pm | 9am - 5pm | 9am - 5pm | 9am - 5pm | 9am - 5pm | 9am - 5pm | 9am - 5pm | 9am - 5pm | 9am - 5pm | 9am - 5pm | ||||||||||
15 | |||||||||||||||||||||
16 | TIM | 9am - 5pm | 9am - 5pm | 9am - 5pm | 9am - 5pm | 9am - 5pm | 9am - 5pm | 9am - 5pm | 9am - 5pm | 9am - 5pm | 9am - 5pm | ||||||||||
Sheet1 |