On the second sheet, create the following named ranges.

How to create a date range drop down list in excel. With drop down calendar in excel worksheet, you can easily select a specific date from it without manually typing. Do not leave blank rows. In the source box, add new list.

Web how to use a drop down list (data validation) to create a date in excel. On the data tab, in the data tools group, click data validation. 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). In the data validation dialog. Web how to create a drop down list calendar (date picker) in excel?

Web select a cell in which you want the dropdown to appear (d3 in our case).