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...
Thank you very much for your help! I am still a bit confused what goes in the parenthesis after SEQUENCE. Let's say I want today's date to auto-fill in cell A1. Then in C1 I want the drop down that lists 30 days sequentially from today's date. How does that formula look EXACTLY for putting in the data validation.
I am getting stuck on what the last entry is supposed to be. I think it should look like : =SEQUENCE(30, right here should be column, then this should be the word TODAY for start, then here it is asking for step)
What does it want for column? Location, quantity, or what? Also, what is step that it is asking for? Commas between everything? My brain feels like it is going to explode. lol
I am getting stuck on what the last entry is supposed to be. I think it should look like : =SEQUENCE(30, right here should be column, then this should be the word TODAY for start, then here it is asking for step)
What does it want for column? Location, quantity, or what? Also, what is step that it is asking for? Commas between everything? My brain feels like it is going to explode. lol
You can use function arguments to aid in construction of the formula.
If you enter =SEQUENCE( then press Shift+F3 (or click the Fx button) then you'll get this menu:
