Calendar Pulldown

%3CLINGO-SUB%20id%3D%22lingo-sub-1606864%22%20slang%3D%22en-US%22%3ECalendar%20Pulldown%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1606864%22%20slang%3D%22en-US%22%3E%3CP%3ECan%20someone%20describe%20how%20to%20insert%20a%20calendar%20pulldown%2Fdate%20picker%20into%20an%20Excel%20365%20worksheet%3F%26nbsp%3B%20It%20seems%20like%20all%20the%20online%20help%20references%202019%20and%20earlier%20versions.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1606864%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1607164%22%20slang%3D%22en-US%22%3ERe%3A%20Calendar%20Pulldown%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1607164%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F768358%22%20target%3D%22_blank%22%3E%40rpryorpe365%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eput%20your%20dates%20in%20a%20column%3C%2FP%3E%3CP%3Ethen%20use%20data%20validation%20option%20list%20then%20select%20the%20range%20%3DP1%3AP40%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethat's%20it%3C%2FP%3E%3CP%3Esee%20the%20file%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Can someone describe how to insert a calendar pulldown/date picker into an Excel 365 worksheet?  It seems like all the online help references 2019 and earlier versions.

1 Reply

@rpryorpe365 

 

put your dates in a column

then use data validation option list then select the range =P1:P40

 

that's it

see the file