Good Morning!

I am trying to display the names of individuals who have vacation days that start and/or end on/before/after a calendar date. The number of vacationers should match the total number of employees on vacation at Disney and Hanna Barbera (I always use cartoon references).

FORMULA: =IFERROR(UPPER(IF($B$8="","",INDEX(VACA[Name],MATCH(0,IF((VACA[StartDate]>=$B$8)*(VACA[EndDate]<=$B$9)*(VACA[Active]="A"),COUNTIF($F$5:$F5,VACA[Name]),""),0)))),"")

The above formula doesn't seem to capture all names, so certainly I am missing how to establish the date criteria in an excel formula.

Any assistance is appreciated.

TEMPScheduling.xlsx