| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Effect of Conditional Formatting, Data Validation | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
| Data Validation Window? | Excel Discussion (Misc queries) | |||
| Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) | |||
| data validation on sth else | Excel Worksheet Functions | |||
Linear Mode
