...In the **Data Validation** dialog box, select **Date** from the **Allow** list, and then specify the valid date formats.
* **Use the **=ISDATE()** function.** The **=ISDATE()** function can be used to check if a value is a valid date. To use this function, enter the following formula into a...