Excel Date Picker

%3CLINGO-SUB%20id%3D%22lingo-sub-1687033%22%20slang%3D%22en-US%22%3EExcel%20Date%20Picker%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1687033%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20add%20date%20picker%20on%20an%20excel%20sheet.%3C%2FP%3E%3CP%3EThe%20goal%20is%20to%20create%20an%20excel%20file%20and%20have%20this%20sent%20to%20users%20to%20fill%20in.%3C%2FP%3E%3CP%3EWhen%20filling%20the%20excel%2C%20and%20click%20on%20the%20start%20date%2C%20a%20calendar%20dropdown%20should%20appear%20and%20users%20select%20the%20date%20from%20the%20calendar%20so%20as%20to%20eliminate%20different%20date%20format%20and%20make%20it%20unique%20across%20the%20document.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20was%20able%20to%20get%20a%20date%20picker%20add-in%20however%20this%20wont%20work%20because%20I%20am%20sending%20to%20users%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eplease%20see%20below%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Promise46_0-1600504563508.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F219814iACEEC06598BA667C%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Promise46_0-1600504563508.png%22%20alt%3D%22Promise46_0-1600504563508.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1687033%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EUser%20Adoption%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1687109%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Date%20Picker%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1687109%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F498592%22%20target%3D%22_blank%22%3E%40Promise46%3C%2FA%3E%26nbsp%3B%2C%2C%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CEM%3ETo%20get%20the%20Date%20Picker%20do%20the%20following%3A%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3COL%3E%3CLI%3EHit%20the%20Developer%20Tab%20%2C%20find%20%26amp%3B%20click%20Design%2C%20and%20next%20to%20it%20is%20Insert.%3C%2FLI%3E%3CLI%3EFrom%20Control%20at%20Right%20bottom%20find%20More%20Control.%3C%2FLI%3E%3C%2FOL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Rajesh-S_0-1600506600226.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F219816i51182F71CE197AE4%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Rajesh-S_0-1600506600226.png%22%20alt%3D%22Rajesh-S_0-1600506600226.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3COL%3E%3CLI%3EFind%20Microsoft%20Date%20%26amp%3B%20Time%20Picker%20Control%2C%20version%206.%3C%2FLI%3E%3C%2FOL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Rajesh-S_1-1600506663434.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F219817i6D408E6A2BB4B2A2%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Rajesh-S_1-1600506663434.png%22%20alt%3D%22Rajesh-S_1-1600506663434.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3COL%3E%3CLI%3ESelect%20it%20%26amp%3B%20finish%20with%20Ok.%3C%2FLI%3E%3CLI%3ENow%20Insert%20the%20Date%20Picker%20on%20Sheet.%3C%2FLI%3E%3CLI%3ERight%20click%20it%2C%20%26amp%3B%20hit%20properties.%3C%2FLI%3E%3CLI%3EFind%2C%20Linked%20Cell%20and%20insert%20cell%20reference%20in%20which%20you%20want%20to%20store%20Date.%3C%2FLI%3E%3CLI%3EReturn%20to%20Developer%20Tab%2C%2C%20click%20the%20Design%20to%20deactivate%20it.%3C%2FLI%3E%3C%2FOL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Rajesh-S_2-1600506773895.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F219818iEFB24C496B256E53%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Rajesh-S_2-1600506773895.png%22%20alt%3D%22Rajesh-S_2-1600506773895.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENow%20click%20the%20button%20on%20Date%20picker%2C%20Excel%20will%20pop%20up%20the%20Calendar%2C%20select%20the%20Date.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%3CSTRONG%3ENote%2C%2C%26nbsp%3B%3C%2FSTRONG%3Eif%20you%20want%20to%20use%20much%20better%20calendar%20control%20then%20you%20need%20to%20use%20V%3CSPAN%3EB%3C%2FSPAN%3EA%20Macro.%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1687173%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Date%20Picker%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1687173%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F498592%22%20target%3D%22_blank%22%3E%40Promise46%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAfraid%20your%20users%20also%20shall%20install%20this%20third-party%20add-in%20to%20use%20it.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOut%20of%20the%20box%20built-in%20data%20picker%20was%20in%20older%20versions%20of%20Excel%2C%20but%20not%20available%20in%20modern%20ones%2C%20at%20least%20in%20Office365%20versions.%20You%20may%20vote%20for%20the%20idea%20to%20add%20it%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304921-excel-for-windows-desktop-application%2Fsuggestions%2F13275054-add-date-picker-to-enable-users-to-select-a-date%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAdd%20'date%20picker'%20to%20enable%20users%20to%20select%20a%20date%20from%20a%20mini%20calendar%20into%20cells%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Contributor

Hello ,

 

I would like to add date picker on an excel sheet.

The goal is to create an excel file and have this sent to users to fill in.

When filling the excel, and click on the start date, a calendar dropdown should appear and users select the date from the calendar so as to eliminate different date format and make it unique across the document.

 

I was able to get a date picker add-in however this wont work because I am sending to users 

 

 

please see below:

 

Promise46_0-1600504563508.png

5 Replies
Highlighted

@Promise46 ,,,

 

To get the Date Picker do the following:

 

  1. Hit the Developer Tab , find & click Design, and next to it is Insert.
  2. From Control at Right bottom find More Control.

 

Rajesh-S_0-1600506600226.png

 

  1. Find Microsoft Date & Time Picker Control, version 6.

 

Rajesh-S_1-1600506663434.png

 

  1. Select it & finish with Ok.
  2. Now Insert the Date Picker on Sheet.
  3. Right click it, & hit properties.
  4. Find, Linked Cell and insert cell reference in which you want to store Date.
  5. Return to Developer Tab,, click the Design to deactivate it.

 

Rajesh-S_2-1600506773895.png

 

 

Now click the button on Date picker, Excel will pop up the Calendar, select the Date.

 

 

Note,, if you want to use much better calendar control then you need to use VBA Macro.

 

 

 

 

Highlighted

@Promise46 

Afraid your users also shall install this third-party add-in to use it.

 

Out of the box built-in data picker was in older versions of Excel, but not available in modern ones, at least in Office365 versions. You may vote for the idea to add it here Add 'date picker' to enable users to select a date from a mini calendar into cells 

Highlighted

@Rajesh-S 

 

Thank you for your response.

It appears Microsoft date and time picker control isn't available for mine .

 

Please what version of excel are you using?

Highlighted

@Sergei Baklan 

 

Thanks for your response.

 

I would use the suggestion link sent 

Highlighted

@Promise46 ,,,

 

Glad to help you,, I'm using both Excel 2013 & 2016 ,,, if you don't have Microsoft Date & Time Picker, then need to manage,,, please Click this,,,  

 

If you feel that my post is useful for you then, you may accept is as "best post/answer"" as well  Like.