Array formula question to identify date range that could cross over into a different sheet

[lilsnoop]

Hello,

I have a work schedule that I'm trying to amend that would calculate vacation, compensatory, sick time, etc between a date range, symbolized by an "X". Once the formula identifies the date range it would then identify via a legend any hours used by that employee for that certain benefit (i.e. sick, vac, comp, etc) that the employee used in that date range. I've attached a sample workbook which I hope has a better explanation in what I'm attempting to accomplish. Currently my array formula will identify the total amount of each benefit individually, but for the entire month; not a specific date range. Any assistance would be greatly appreciated or if there are any suggestions as an alternate way to accomplish this task that too would be appreciated!