Data Validation

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
 
K

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Validation List: Text Size Query 2
Data validation won't restrict user input - please help 1
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Data Validation 1
Multiple Data Validation Checks 3
Data Validation using Unique Values 2
Data Validation 2
Data Validation - 2 decimal places 4

Top