Data Validation

  • Thread starter Thread starter Neil Pearce
  • Start date Start date
N

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
 
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
 
Back
Top