Tip Printed from ExcelTip.com

---

Validating Date Entries


To validate date entries:

1. Select a range of cells with the date to validate.
2. From the Data menu, select Validation, and then select the Settings tab.
3. In the Allow dropdown list, select Date.
4. In the Data dropdown list, select between.
5. In the Start date box enter 1/1/2004.
6. In the End date box enter 12/31/2004.
7. Click OK.