How to Create a Data Validation with Date Range


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