This formula will return the result in one cell for all the dates with the OR function
OR
=IF(OR(($I$2>=L2:L5)*($I$2<=M2:M5)),"YES","NO")