Yes, I meant 12/31/20081 as the wrong date. I use filters to run reports and
wrong dates mess up my reports. Data validation did the trick. Thank you!

"David Biddulph" wrote:

You can use data validation to reject an invalid date such as 31/12/08 if
you want 12/31/08, but not if someone puts in 7/11/08 instead of 11/7/08.
--
David Biddulph

"jvq" wrote in message
...
How can I keep the mm/dd/yy format to display an error or message when
other
users enter the wrong date: ie 12/31/20081?