Question: create a data validation rule that will only accept date values?
Answer: Select cell C4, and on the Excel Ribbon, click the Data tab. Click Data Validation (click the upper section of the command) On the Settings tab of the data validation dialog box, from the Allow drop down, click Date.