Let say you need to create a data validation for dates in which you want to use a specific date range.
In simple words, you want when a user enters a date in a cell that should be within a range of dates which you specify.
Well, this can be done by using a custom formula based on the AND function and a simple way by defining dates in the date range option in data validation.
These both methods will restrict a user to enter a date out of the range.
So, let learn this thing.
Steps to Create Date Validation with Date Range
- First of all, select the cell where you want to apply this data validation rule.
- Now, go to Data Tab ⇢ Data Validation ⇢ Data Validation.
- From here in data validation dialog box, s