in H6:
=COUNTIFS($B$2:$B$9,"<="&H5,$C$2:$C$9,">="&H5)