How to set a date in the excel drop-down menu

1. Open the excel document and click "data" -- "data validity", as shown in the following figure.

2. Click "data validity", as shown in the following figure.

3. Now we have set the menu in the pop-up menu, as shown in the following figure.

Set date select drop-down menu

1. As shown in the following figure, I enter cell c d e into the year, month, and day respectively, as shown in the figure.

2. Now we set "year". As shown in the figure, we enter 2014 ~ 2018

3. We also set the monthly subscription as above, and then enter 1-12 months.

4. The date setting method is the same as step 2 or step 3 for 1-31 days.

5. After the settings are completed, you can quickly select a date here.