How to limit the Excel table to only enter dates before 2019_Excel table to limit the entry of only dates before 2019 operation tutorial

Today PHP editor Strawberry brings to you: How to limit the input date in Excel table to before 2019? In Excel tables, we often need to limit the date range entered by users to ensure the accuracy and reliability of the data. This article will guide you on how to use Excel formulas and data validation functions to easily limit the dates in the table to before 2019.

1. First find the Excel document that needs to be edited, double-click to open it and enter the editing interface.

2. In the editing area, select the cells that need to limit the date input range.

3. In the upper ribbon, click the [Data] tab.

4. Click the [Data Validation] button in the [Data Tools] group.

5. In the pop-up [Data Verification] dialog box, select [Date] in the [Allow] drop-down box.

6. Select [Less than or equal to] in the [Data] drop-down box, enter [2018/12/31] in the [Date] box, and click OK.

7. Return to the editing area. When entering a date that is not before 2019 (for example: 2019/1/1) in the set cell, there will be an error message stating Setup successful.

The above is the detailed content of How to limit the Excel table to only enter dates before 2019_Excel table to limit the entry of only dates before 2019 operation tutorial. For more information, please follow other related articles on the PHP Chinese website!