Need to find the date between two other dates with one condition

Hello Everyone,

I need to find the time in column C which is a time between B and D. the options are on F and G.
The Vehicle should be the same with column A.

I'm using this formula:

{=IF(SUMPRODUCT(--($F$2:$F$756=$A2),--($G$2:$G$756>=$B2),--($G$2:$G$756<=$D2),($G$2:$G$756))>0,SUMPRODUCT(--($F$2:$F$756=$A2),--($G$2:$G$756>=$B2),--($G$2:$G$756<=$D2),($G$2:$G$756)),"")}

The problem is that if there are multiple results, the dates are being added. I'm getting years 2135, 2253 and 2371 on this file.\

I only need the first result and not add the dates that qualify with the formula.

Please refer to the attached file.

Thank you.

=IFERROR(INDEX($G$1:$G$756,AGGREGATE(15,6,ROW($G$2:$G$756)/($F$2:$F$756=$A2)/($G$2:$G$756>=$B2)/($G$2:$G$756<=$D2),1)),"") not array

Originally Posted by tim201110

=IFERROR(INDEX($G$1:$G$756,AGGREGATE(15,6,ROW($G$2:$G$756)/($F$2:$F$756=$A2)/($G$2:$G$756>=$B2)/($G$2:$G$756<=$D2),1)),"") not array

This Worked. Thank you.