Data Validation

D

DaveMoore

I want to data validate a cell to accept only dates that may be prior to 1900.
Can this be done?
If so, how?
TIA for any responses
 
P

Peo Sjoblom

Dates prior to 1900 will be text so you have to come up with some criteria on
how to enter text dates, maybe look for the last four characters as in
01/03/1888 and use custom

=--(RIGHT(A9,4))<1900

Regards,

Peo Sjoblom
 

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

Excel 2013: How to ensure a cell is not left blank by users? (Not using VBA) 0
VLOOKUP & Data Validation 0
how to do data validation in excel 1
Testing a cell value for a specific weekday. 4
Validation of cell based on Drop down list 1
Display weeks from a Milestone 0
Internal Data Integrity (Type 4) Details Needed 1
custom data validation on cells with data validation values 2

Top