Bank holidays with shift patterns

[tjack_87]

Hi all.
Hopefully you can help me. Say for example in A1 to G1 i have Sunday through to Saturday. In A2 to G2, i put the number of hours a colleague is due to work for the day above. If the colleague isnt due to work, i leave the cell blank

In another part of the spreadhsheet, say H1 to H8 i have a list of this years bank holidays.

I also have a start and end date in J1 and J2, as the colleague may not have worked with us for the entire year.

I have managed to get excel to count how many bank holidays have passed between J1 and J2, but now i need to know how many of those bank holidays a colleague was actually contracted to work.

Is this something i can do based on my current data?

 

[DRSteele]

You can investigate the use of the function NETWORKDAYS.INTL

If you post some sample data, forum members can more easily help you; see the link in my signature below.