Use Validation to restrict date entries

Uploaded time: March 28, 2022 Difficulty Beginner

A free Office suite fully compatible with Microsoft Office

Free Download
Free download

Use Validation to restrict date entries

Use Validation to restrict date entries

When editing a spreadsheet, we may want to restrict the contents to ensure effectiveness, such as requiring the dates cannot exceed today. Today we will tell you how to restrict the input dates using Validation.

First, select the cell range that contains the dates. Click Validation in the Data tab or use the shortcutsAlt+D+L.

The Data Validation dialog will pop up, where you can select Date at Allow. Then, click the Data drop-down button to restrict the date range. Here, we select less than or equal to. Enter 2022/03/22 at End date before clicking OK.


Now, let's enter a date after 2022/03/22, such as 2022/4/1. An error alert will appear, indicating the Validation function works.


This is all about using Validation to restrict date entries. Did you get it?

WPS Spreadsheet is a powerful chart and form processor. In WPS Academy, you can learn not only how to use Spreadsheet to sort out data but also how to corporate numeric information into graphs. By watching the step-by-step tutorials on WPS Academy, you will become a spreadsheet expert soon.