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
Highlighted

@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.

Ok, will do. Thanks!@Twifoo 

Highlighted
No problem, thanks!
Related Conversations
IF statements and conditional formatting
clare1981 in Excel on
1 Replies
Reverse numbers and characters in worksheet
David_Gerrior in Excel on
1 Replies
Sumifs
Jsbluemoon82 in Excel on
3 Replies
Excel formula similiar to texjoin
Carlo74 in Excel on
0 Replies
everything is black and white in excel
Gold4trees in Excel on
1 Replies
Deleting unwanted rows and columns
chipg900 in Excel on
4 Replies