Formula to find the earliest date in excel base on a given date and text

Try with dynamic range

Formula:

=AGGREGATE(15,6,OFFSET($I$1,1,,COUNTA(I:I))/(OFFSET($I$1,1,,COUNTA(I:I))>D2)/(OFFSET($H$1,1,,COUNTA(H:H))=A2),1)