Cell - date format only, do not allow text in field

[Grandma8]

I am creating a purchase order form in Excel and want only a date to be in the cell - no text.

The cell format is set to mm/dd/yy. I used data validation to display the input message when the field is selected. I do not know how to "code" or add a formula to limit the data entered to a date only. The final version of the form will be password protected.

Help will be much appreciated!

 

[gaz_chops]

When you set the data validation there is an option in the "Allow" dropdown for date.