How to Use Data Validation for Entering Dates in Excel

When we want to enter data in Excel, in order to reduce data entry errors, we can use the data validation function to set the valid range of the data. Let’s take the below pic as an example. The picture shows the grades of the students. The score must be between 0 and 100. To […]