date format

[jvq]

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?

 

[Satti Charvak]

You can even use conditional formatting with the below formula:

=ISERR(MONTH($F$9))

and put some color like red. So any cell where the data is not in date
format will, change to red color.

but this formatting and the solution by david will not work if somebody
enters 1/2/2008 (1st feb 2008) instead of 2/1/2008 (2nd jan 2008).

 

[Dave Peterson]

I think you should allow the users to enter the date in any format that's
valid.

But you can format the cell anyway you want--but I would use an unambiguous
format so that it's easy to verify the dates.

 

[Bob I]

i wonder if he meant 20081 not being a valid year?

 

[Dave Peterson]

Could be, but then I bet the non-ambiguous date format would show that as an
error right away. And I bet David's data|validation rule would catch that.

 

[jvq]

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!