You can simply check whether the start date is later than the reference start date and the end date is earlier than the reference end date:
=AND(C3>=A3, D3<=B3)