I need Excel to validate that an entry in a date field is correct.
Specifically, if someone includes the day of the week in an entry
(e.g., Wed 02/16/05) I need Excel to display "You entered an incorrect
date format. Enter the date as mm/dd/yy and do not include the day of
the week."

Can anyone tell me how to do that?

Ken Elder
Oklahoma City


--
kenelder
------------------------------------------------------------------------
kenelder's Profile: http://www.excelforum.com/member.php...o&userid=20020
View this thread: http://www.excelforum.com/showthread...hreadid=346034