I want to get employee aviability based on date range of their holiday.

Start dates and end dates are date ranges of holiday and I want to get list of employees outside those ranges.
What I want to do is enter date range, for example 16.7.- 17.7., and get the available employees for those two days(who are NOT on holiday, so not between start date and end date).

I tried using this command for filtering:
=FILTER(A2:C7;(B2:B7>=E2)*(C2:C7<=F2);"Not available")

However, on this example I only get “Employee A” and “Employee E” but not the “Employee C” because of the criteria:
C2:C7<=F2