WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

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

correct-icon

Microsoft-like interface, easy to use.

Free Download

Windows • MacOS • Linux • iOS • Android

banner

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.

01_03.gif

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.

01_4.gif

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.