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
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies