With drop down calendar in excel worksheet, you can easily select a specific date from it without manually typing.

How to create a date range drop down list in excel. In the data validation dialog. On the data tab, in the data tools group, click data validation. On the first sheet, select cell b1.

Open a new spreadsheet in excel. Web select a cell in which you want the dropdown to appear (d3 in our case). Do not leave blank rows.

On the second sheet, create the following named ranges. This will open the code window for that. Web enter =age in the “source” box (if you named your cell range something else, replace “age” with that name).

Web how to create a drop down list calendar (date picker) in excel?