How to format an array portion of a MATCH function?

[ausable7400]

Hi Folks -

I have the following formula:

=IFERROR(INDEX(Results!$H:$H,AGGREGATE(15,6,ROW(Results!$H$2:$H$500000)/((Results!$B$2:$B$500000='Cover Page'!$C$5)*ISNUMBER(MATCH(Results!$F$2:$F$500000,$C$4:$G$4,0))*ISNA(MATCH(Results!$H$2:$H$500000,$B4:$B$4,0))),1)),"")

What I need to do is format the array portion of this:

MATCH(Results!$F$2:$F$500000,$C$4:$G$4

$C$4:$G$4 contains dates in a format that doesn't match the source. Therefore, I"m trying to do something like TEXT(cell, "mm-dd-yyyy") but it doesn't seem to work. Any ideas?

Or is the easier thing to do is reformat $C$4:$G$4 to the correct format?

Thank you!