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!
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!