Full worksheet is

I need to retrieve the 1st value of the week for the"6AM" column C highlighted in

**and the last value of the week for the "6PM" column E also in**

**GREEN****GREEN**

I have populated columns M and O using MAXIFS and MINIFS formulas as suggested which have worked great.

My data only uses a M - F business calendar. and because of Holidays, I cannot figure out the correct function/formula to retrieve the correct data. For example, we had a holiday on 4/2/2021 - so the correct value for "6PM" for the week of 3/28/2021 - 4/3/2021 would be the value in cell

**E6**, opposed to whatever value is on a Friday with no Holidays.

I think I need two filters. First, filter the dates if they are within the week referenced in columns K and L. Second, retrieve the 1st value of the week for the 6AM column of C, and last value of the week for column E.

I have tried using IFERROR function with index/match and filter but cannot get things to work. Any suggestions are much appreciated.