Hello Experts,

I have an interactive spreadsheet in which users enter data into
approx. 5 columns.

In one of the columns, I would like users to enter the date in
yyyymmdd format, e.g., 20070226. I know they won't get it right so I
would like to preemptively stop it.

I've used data validation on some of the other columns, but have found
it not applicable with the scenario.

It would be nice to code the column with some sort of substring, e.g.,
first four characters =2007; next two between 01 and 12; next two
between 01 and 31-knowing, however, this would not completely solve my
problem; it would help it; however.

Any thoughts?

alex