1. Turn on the computer and double-click to enter the Excel form; 2. Click to select a cell; 3. Click to enter the formula, and then click to enter the insert function; 4. Click Expand to select the Date and Time category, and then check the functions below.

In excel table, we can set the range of input date for cells, so that the input date is the date of the time period we need. So, how to set it up? The following small series will introduce how to set a limited date in an Excel table:

1. First, open an excel table; 2. Select the cell to set; 3. Click "Data Validity" under the data menu bar; 4. Click the setting menu and select "Date" if necessary; 5. Then set the conditions, greater than, less than or between, in which Bian Xiao chooses greater than, then set the start date and click OK; 6. After setting, if the date entered is not within the setting range, an error prompt will appear.