How to format an array portion of a MATCH function?

Hi Folks -

I have the following formula:

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

$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!

There are instructions at the top of the page explaining how to attach your sample workbook.