I want to throw an error if the date entered is a future date.
The validation rule won't accept <=Date()
When I enter that in the Data Validation field, it doesn't matter what date I enter, nothing happens. It will take =Date() just fine though. What am I doing wrong?
The validation rule won't accept <=Date()
When I enter that in the Data Validation field, it doesn't matter what date I enter, nothing happens. It will take =Date() just fine though. What am I doing wrong?