Formula Needed!

Copper Contributor

Hello there everybody, I need a little help with a small excel-tool I'm trying to create.
It's the first time I'm trying to create a tool by myself, so expect a lot of ignorance on my end.

 

So: The point of the tool is supposed to let members of the team I'm in to log issues they're experiencing with a website we're testing, and along with describing the different issues, I've added different drop-down cells for them to easily choose out of a few pre-set options (for instance browser used during testing).

 

Now, ideally, what I'd like is a set of dates the user can choose from, in a drop-down menu, starting from a specific date and ending in the current day. Is that possible? I'm awful at formulas, so if anybody could help me I'd be very grateful! :)

1 Reply

@ArrJayBee 

In the attached file: 

1. Fill in the Start Date in B1; and 

2. Copy the formula in B2, down the rows, until the result becomes an empty text. 

Note this defined name in the Source box of the drop-down list: 

NameFormula
Dates

=Sheet1!$B$1:INDEX(Sheet1!$B:$B,COUNT(Sheet1!$B:$B))

Your drop-down list will look like D4.