Date Validation
Date Validation can be set -up in Excel. Select date in the allow box and pick up the appropriate criteria.
Follow the below steps to set-up date validation:
Step 1: Select the cell
Select the cell where you’d be applying the data validation
Step 2:
Data Validation in Excel
Microsoft Excel is a powerful tool and is widely useful too. It has various features to ease our work. One such feature is Data Validation. Now suppose you want the user to enter some specific values into the cells and for that, you need to set some pre-defined rules so that the user wouldn’t be able to enter other values and that’s where Data Validation steps in.