=IF(AND(B11INDEX(A2:D8;MATCH(B10;A2:A8;0);2);B11< INDEX(A2:D8;MATCH(B10;A2:A8;0);3));INDEX(A2:D8;MAT CH(B10;A2:A8;0);4);0)

column A = ID#
column B = first date of date range
column C = last date of date range
column D = return date

cell B10 = ID#
cell B11 = Date

Hope this helps.