Formula for shift roster

[octjan]

Hi,

I update a roster for the entire month in the attached format and intend to capture shift details.


Row 1 indicates the holidays marked as 'H' and row 4 captures the individuals working in the night shift.


For costing purposes I want to count how many times BB has worked the night shift in the month when the following day was a holiday.


In this example the answer I'm expecting is 2 in Cell J2 where BB worked on 31 May and 04 Jun when the following day was a holiday

Would appreciate some help in creating a formula to capture this info. Thanks in advance!

[Richard Buttrey]

Hi and welcome to the forum

Please Login or Register  to view this content.

should do it.