Home

Formula Needed!

%3CLINGO-SUB%20id%3D%22lingo-sub-725221%22%20slang%3D%22en-US%22%3EFormula%20Needed!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-725221%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20there%20everybody%2C%20I%20need%20a%20little%20help%20with%20a%20small%20excel-tool%20I'm%20trying%20to%20create.%3CBR%20%2F%3EIt's%20the%20first%20time%20I'm%20trying%20to%20create%20a%20tool%20by%20myself%2C%20so%20expect%20a%20lot%20of%20ignorance%20on%20my%20end.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%3A%20The%20point%20of%20the%20tool%20is%20supposed%20to%20let%20members%20of%20the%20team%20I'm%20in%20to%20log%20issues%20they're%20experiencing%20with%20a%20website%20we're%20testing%2C%20and%20along%20with%20describing%20the%20different%20issues%2C%20I've%20added%20different%20drop-down%20cells%20for%20them%20to%20easily%20choose%20out%20of%20a%20few%20pre-set%20options%20(for%20instance%20browser%20used%20during%20testing).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENow%2C%20ideally%2C%20what%20I'd%20like%20is%20a%20set%20of%20dates%20the%20user%20can%20choose%20from%2C%20in%20a%20drop-down%20menu%2C%20starting%20from%20a%20specific%20date%20and%20ending%20in%20the%20current%20day.%20Is%20that%20possible%3F%20I'm%20awful%20at%20formulas%2C%20so%20if%20anybody%20could%20help%20me%20I'd%20be%20very%20grateful!%20%3A)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-725221%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-727364%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20Needed!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-727364%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F367720%22%20target%3D%22_blank%22%3E%40ArrJayBee%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20attached%20file%3A%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20Fill%20in%20the%20Start%20Date%20in%20B1%3B%20and%26nbsp%3B%3C%2FP%3E%3CP%3E2.%20Copy%20the%20formula%20in%20B2%2C%20down%20the%20rows%2C%20until%20the%20result%20becomes%20an%20empty%20text.%26nbsp%3B%3C%2FP%3E%3CP%3ENote%20this%20defined%20name%20in%20the%20Source%20box%20of%20the%20drop-down%20list%3A%26nbsp%3B%3C%2FP%3E%3CTABLE%20border%3D%220%22%20cellspacing%3D%220%22%20cellpadding%3D%220%22%3E%3CTBODY%3E%3CTR%3E%3CTD%3EName%3C%2FTD%3E%3CTD%3EFormula%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EDates%3C%2FTD%3E%3CTD%3E%3CP%3E%3DSheet1!%24B%241%3AINDEX(Sheet1!%24B%3A%24B%2CCOUNT(Sheet1!%24B%3A%24B))%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3EYour%20drop-down%20list%20will%20look%20like%20D4.%3C%2FP%3E%3C%2FLINGO-BODY%3E
ArrJayBee
Occasional Visitor

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.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies