Assuming they are entered in a legitimate format that would be interpreted
as a date,

format the column as Date,


in and empty cell put in the digit 1

copy that cell (select the cell, then edit=copy)

Select you bad dates

Do Edit=Paste Special then select Values and Multiply.

This will convert them to dates.

--
Regards,
Tom Ogilvy

"KR" wrote in message
...
Tom-
As always, your advice is greatly appreciated.
I had tried the match function before posting, but was unable to get the
second argument to work. I think the issue was that I was using
CompareArray() and didn't need the parantheses.

I still am getting an error, but (after some searching) I figured out that
the dates in my source of MyVal apparently were entered as text instead of
actual dates <groan. Now my first job will be to write another macro to
change them all to dates <sigh.

Thanks again for your assistance!
Keith

"Tom Ogilvy" wrote in message
...
res = application.Match(myval,compareArray,1)

see the rules for the worksheet function Match (In Excel, not VBA, help)
and
adjust to suit your scenario.

--
Regards,
Tom Ogilvy