Hi, I am trying to think of a way, badly, of combining information together.
As you can see, I have 5 staff members that each work a different shift pattern each week.
I want to see who gets certain double days off in a period of time.
In this example, I have 3 weeks worth of shifts that shows one person getting 2 Monday and Tuesdays off, some getting 1 and even 0.
I'd like my results to go in the cells B16-B20 as they are above.
I believe a combination of if, and, & or may be the best answer (based on a search here) but I can not figure out what to do.
Any help will be much appreciated.
As you can see, I have 5 staff members that each work a different shift pattern each week.
I want to see who gets certain double days off in a period of time.
In this example, I have 3 weeks worth of shifts that shows one person getting 2 Monday and Tuesdays off, some getting 1 and even 0.
I'd like my results to go in the cells B16-B20 as they are above.
I believe a combination of if, and, & or may be the best answer (based on a search here) but I can not figure out what to do.
Any help will be much appreciated.