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?