To ensure that a date column is used correctly, you can effectively insert a calendar in Excel, using an Excel date picker.

How to Insert a Combo Box in Excel 2010. Combo boxes are a useful way of entering data into an Excel spreadsheet, combining the flexibility of a text field with the convenience of a list box.