How to use a drop down list (data validation) to create a date in Excel.
This technique creates a fully functional date serial number that Excel recognizes so you can perform any required date-based calculations or output display changes.
Dates from Text in Excel (msft)
Data Validation (msft)
Data Validation for Dates (contextures)