Hi,

Why not just format the whole column to the desired format, then any dates
legal dates must be formatted as you want?

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"exceed_novice" wrote:

Hi,
We receive a sheet with about 1000 rows and need to do some
validation
on that sheet before it gets processed. One of the validations is for
the column with the date.
I need to validate that the date is in the "mm/dd/yyyy" format. I
have
looked and tried different but have not been able to do this. Could
somebody tell me how to validate the date.

Thank You