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.
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.
Also Read:
- 1. How can we use the data validation feature
- 2. Use Validation to restrict data change
- 3. Use Validation to prevent duplicate values
- 4. How to protect a word document and restrict editing
- 5. Data validation to help you limit the content of your forms
- 6. Clear and avoid duplicates entries in WPS Spreadsheet
Does this video help you?