Rather, select the cell, then go to Data > Validation. In the drop down choose "Date" and it will give you possible beginning and ending dates. Now everything entered has to be Date. Also, you have a pop-up error message, if you select the last tab "Error Alert".
old, slow, and confused
but at least I'm inconsistent!
its working, but I still have a Q?.
How to choose possible beginning and ending dates?
It is an order form, so the day needs to be current and going forward.
Confuzed on that too. I placed the "grater than", but not sure if it is correct.