ExcelBanter - Data Validation

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Data Validation (https://www.excelbanter.com/excel-worksheet-functions/10250-data-validation.html)

DaveMoore

Data Validation

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

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

"DaveMoore" wrote:

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

All times are GMT +1. The time now is 02:04 AM.