Forum Discussion
Excel drop down lists
Hello- How do I create a formula for sequential dates in a drop down list? For example: I would like to be able to click the drop-down to pick Thursday, August 17, Friday, August 18, Saturday, Aug...
The data validation won't accept a dynamic array but you can refer to a spill in the sheet containing the dates.
This formula produces an array of 30 dates starting from today:
=SEQUENCE(30,,TODAY())
Place it somewhere in the sheet. Then in data validation, refer to the spill:
I actually need the sequence as a drop down that the user can choose one of the dates from to automatically fill in the cell. I would like it to drop down a list of 30 dates from today forward that can be chosen. If that isn't possible, is there a way to have a calendar pop-up to choose a date from?