Home

adding a drop down calender in excel

%3CLINGO-SUB%20id%3D%22lingo-sub-745940%22%20slang%3D%22en-US%22%3Eadding%20a%20drop%20down%20calender%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-745940%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I'm%20a%20beginner%20with%20excel.%20I'm%20trying%20to%20figure%20out%20how%20to%20make%20a%20calender%20pop%20up%20when%20clickingon%20a%20drop%20down%20menu.%20I%20have%20office%2016.%20Any%20help%20would%20be%20appreciated.%20Thanks!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-748235%22%20slang%3D%22en-US%22%3ERe%3A%20adding%20a%20drop%20down%20calender%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-748235%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F373638%22%20target%3D%22_blank%22%3E%40Patrick0826%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHello!%20You've%20posted%20your%20question%20in%20the%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FCommunity-Discussion%2Fbd-p%2FCommunityQuestions%22%20target%3D%22_blank%22%3ECommunity%20Discussion%20space%3C%2FA%3E%2C%20which%20is%20intended%20for%20discussion%20around%20the%20Tech%20Community%20website%20itself%2C%20not%20product%20questions.%20I'm%20moving%20your%20question%20to%20the%20Excel%20space%20-%20please%20post%20Excel%20questions%20here%20in%20the%20future.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-748579%22%20slang%3D%22en-US%22%3ERe%3A%20adding%20a%20drop%20down%20calender%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-748579%22%20slang%3D%22en-US%22%3EI%20strongly%20suggest%20that%20instead%20of%20a%20calendar%20drop-down%2C%20you%20use%20a%20date%20drop-down.%20The%20first%20allows%20any%20date.%20The%20second%20limits%20the%20input%20date%20to%20those%20included%20in%20the%20drop-down.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-750066%22%20slang%3D%22en-US%22%3ERe%3A%20adding%20a%20drop%20down%20calender%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-750066%22%20slang%3D%22en-US%22%3E%3CP%3EOk%2C%20will%20do.%20Thanks!%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280482%22%20target%3D%22_blank%22%3E%40Twifoo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-750067%22%20slang%3D%22en-US%22%3ERe%3A%20adding%20a%20drop%20down%20calender%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-750067%22%20slang%3D%22en-US%22%3ENo%20problem%2C%20thanks!%3C%2FLINGO-BODY%3E
Highlighted
Patrick0826
New Contributor

Hi, I'm a beginner with excel. I'm trying to figure out how to make a calender pop up when clickingon a drop down menu. I have office 16. Any help would be appreciated. Thanks!

 

4 Replies

@Patrick0826 

Hello! You've posted your question in the Community Discussion space, which is intended for discussion around the Tech Community website itself, not product questions. I'm moving your question to the Excel space - please post Excel questions here in the future. 

Highlighted
I strongly suggest that instead of a calendar drop-down, you use a date drop-down. The first allows any date. The second limits the input date to those included in the drop-down.
Highlighted

Ok, will do. Thanks!@Twifoo 

Highlighted
No problem, thanks!
Related Conversations
Excel Help needed
NojMc in Excel on
1 Replies
IFS with AND and multiple falses
Bradley79 in Excel on
1 Replies
Matching date input to the formatted date display
Erikstg in Excel on
2 Replies
Can I use wildcards with the new FILTER function
StuLux23 in Excel on
14 Replies