Provide certain dates in cell

%3CLINGO-SUB%20id%3D%22lingo-sub-2293181%22%20slang%3D%22en-US%22%3EProvide%20certain%20dates%20in%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2293181%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20provide%20dates%20for%20user%20to%20choose%20from%20in%20a%20certain%20cell.%26nbsp%3B%20For%20instance%2C%20i%20want%20user%20to%20be%20able%20to%20pick%20from%20either%20a%20calendar%20or%20drop%20down%20list%20in%20filter%20a%20certain%20date.%26nbsp%3B%20I'm%20making%20an%20meeting%20agenda%20tracker%20and%20i'd%20like%20the%20user%20to%20be%20able%20to%20choose%20the%20date%20that%20a%20certain%20discussion%20needs%20to%20be%20on%20the%20agenda%20for%20a%20certain%20meeting%20date.%26nbsp%3B%20The%20dates%20would%20be%20the%20year%202021%20and%20i%20would%20like%20the%20end%20user%20to%20pick%20what%20date%20something%20would%20be%20ready%20for%20discussion%20at%20a%20specific%20meeting.%26nbsp%3B%20meeting%20dates%20are%20every%20other%20thursday%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2293181%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2293746%22%20slang%3D%22en-US%22%3ERe%3A%20Provide%20certain%20dates%20in%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2293746%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1037043%22%20target%3D%22_blank%22%3E%40karin_sassa_1229%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWith%20your%20permission%2C%20if%20I%20can%20recommend.%20It%20can%20help%20us%20all%20if%20you%20upload%20an%20Excel%20file%20(without%20sensitive%20data)%2C%20no%20picture.%3C%2FP%3E%3CP%3EEven%20if%20it%20is%20said%20that%20a%20picture%20can%20say%20a%20thousand%20words%2C%20it%20is%20certainly%20not%20in%20the%20case%20of%20Excel%2C%20on%20the%20contrary%20in%20some%20cases.%3C%2FP%3E%3CP%3EThis%20would%20also%20be%20a%20blessing%20for%20all%20of%20us%2C%20as%20we%20can%20understand%20the%20problem%20much%20better%2C%20a%20win-win%20situation%20for%20everyone.%3C%2FP%3E%3CP%3E*%20Knowing%20the%20Excel%20version%20and%20operating%20system%20would%20also%20be%20an%20advantage.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20order%20not%20to%20be%20misunderstood%2C%20in%20the%20community%20it%20is%20the%20aim%20of%20excel%20users%20to%20give%20help%20on%20their%20project%20(from%20Excel%20users)%2C%20or%20rather%2C%20to%20provide%20food%20for%20thought%20and%20not%20to%20deliver%20finished%20work%20or%20finished%20ideas.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I need to provide dates for user to choose from in a certain cell.  For instance, i want user to be able to pick from either a calendar or drop down list in filter a certain date.  I'm making an meeting agenda tracker and i'd like the user to be able to choose the date that a certain discussion needs to be on the agenda for a certain meeting date.  The dates would be the year 2021 and i would like the end user to pick what date something would be ready for discussion at a specific meeting.  meeting dates are every other thursday 

2 Replies

@karin_sassa_1229 

With your permission, if I can recommend. It can help us all if you upload an Excel file (without sensitive data), no picture.

Even if it is said that a picture can say a thousand words, it is certainly not in the case of Excel, on the contrary in some cases.

This would also be a blessing for all of us, as we can understand the problem much better, a win-win situation for everyone.

* Knowing the Excel version and operating system would also be an advantage.

 

In order not to be misunderstood, in the community it is the aim of excel users to give help on their project (from Excel users), or rather, to provide food for thought and not to deliver finished work or finished ideas.

 

 

 

Thank you for your understanding and patience

 

 

Nikolino

I know I don't know anything (Socrates)

@karin_sassa_1229 

As variant you may generate list of possible dates and make data validation on it.