![how to add drop down menu in excel 2016 how to add drop down menu in excel 2016](https://cdn4syt-solveyourtech.netdna-ssl.com/wp-content/uploads/2019/12/how-to-add-rows-in-excel-5.jpg)
![how to add drop down menu in excel 2016 how to add drop down menu in excel 2016](https://i.stack.imgur.com/rhfqq.jpg)
So, if we want to change start and end dates, change them, and according to the changes made, validation too will vary. We can only enter dates between the start and end dates in the selected cell. We will have named ranges instead of direct entry of dates.
![how to add drop down menu in excel 2016 how to add drop down menu in excel 2016](https://www.lifewire.com/thmb/Gy5LWee-A_-L6NwxblU-r2ZpeCE=/3040x1664/filters:no_upscale():max_bytes(150000):strip_icc()/ExcelDropDownList1-a9a51700584a47abae97fcb9285ebfec.jpg)
Then, click on “ OK.”As a result, it will create a named range.