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
 
Top