=AND(AND(C1>=A1,C1<=B1),AND(D1>=A1,D1<=B1))
.... returns TRUE when both the criteria begin date and criteria end
date are between employment start and employment end dates.