Jun 27 2019 07:36 AM
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! :)
Jun 27 2019 10:24 PM
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:
Name | Formula |
Dates | =Sheet1!$B$1:INDEX(Sheet1!$B:$B,COUNT(Sheet1!$B:$B)) |
Your drop-down list will look like D4.