Data Validation

[Neil Pearce]

Dear all,

I can use Data Validation to restrict a user's input between to specified
dates.

I wish to enable the user to be able to additionally select an "Unknown"
option i fthe date is not known.

Is this possible?


Your help, as always, is very much appreciated.


Thank -you.

Neil

 

[KC]

Neil,
can you try using Custom option under validation criteria, and use this
formula for validation
=OR(AND(B1>=DATEVALUE("01-Jan-2009"),B1<=DATEVALUE("31-Dec-2009")),B1="Unknown")

where B1 is the cell beging validated.

would this help?
-kc