-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Avoiding blank date in data validation
- Thread starter pilot
- Start date
-
- Tags
- data validation
JazzSP8
Well-known Member
- Joined
- Sep 30, 2005
- Messages
- 1,233
- Office Version
- 365
- Platform
- Windows
Hi
Might be a bit late but you could try changing the Data Validation to 'Allow Custom' and then use a formula like;
That'll stop Blank Cells, Text in the Cells and Dates less than 08/01/2011 (Serial: 40551)
Data Validation can sometimes be broken though (if you allowed text then a space or any kind of text would let you get round it for example) so you might want to try your best to break it before using it.
Might be a bit late but you could try changing the Data Validation to 'Allow Custom' and then use a formula like;
Code:
=AND(NOT(ISBLANK(A1)),NOT(ISTEXT(A1)),A1>=40551)Data Validation can sometimes be broken though (if you allowed text then a space or any kind of text would let you get round it for example) so you might want to try your best to break it before using it.
Upvote
0
Looks like this should work but for some reason, it still allows a blank cell to pass validation. Currently the cell reads "Enter date here" in an unlocked cell of a protected sheet. Deleting that text to leave a blank cell still passes data validation with your sugested formula. Any other thoughts?
Upvote
0
Similar threads
- Question
