WPS Office

Free All-in-One Office Suite with PDF Editor


Edit Word, Excel, and PPT for FREE.


Read, edit, and convert PDFs with the powerful PDF toolkit.


Microsoft-like interface, easy to use.

Free Download

Windows • MacOS • Linux • iOS • Android


Use Validation to restrict date entries

Uploaded time: March 28, 2022 Difficulty Beginner

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.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.