Web how to use a drop down list (data validation) to create a date in excel.
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. Web select a cell in which you want the dropdown to appear (d3 in our case). On the second sheet, create the following named ranges.
In the source box, add new list. Web how to create a drop down list calendar (date picker) in excel? Web enter =age in the “source” box (if you named your cell range something else, replace “age” with that name).
This technique creates a fully functional date serial number that excel recognizes so you can perform. In the data validation dialog. On the first sheet, select cell b1.
On the data tab, in the data tools group, click data validation.