Forum Discussion
Excel Date Picker
MVPromise ,,,
To get the Date Picker do the following:
- Hit the Developer Tab , find & click Design, and next to it is Insert.
- From Control at Right bottom find More Control.
- Find Microsoft Date & Time Picker Control, version 6.
- Select it & finish with Ok.
- Now Insert the Date Picker on Sheet.
- Right click it, & hit properties.
- Find, Linked Cell and insert cell reference in which you want to store Date.
- Return to Developer Tab,, click the Design to deactivate it.
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.
- EvSchmidtSep 28, 2023Copper Contributor
Rajesh_Sinha Aware that this is way after your initial inquiry, but I recently noticed that the exact functionality you are looking for is now available in Excel Online. By simply setting the cell number format to Date (any Date format, including custom ones, works) the person entering the date into the cell is prompted with a calendar date picker.
- MVPromiseSep 25, 2020Brass Contributor
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?
- Rajesh_SinhaSep 26, 2020Steel Contributor
MVPromise ,,,
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.
- MattwinterrshqFeb 26, 2024Copper Contributor
Rajesh_Sinha Does not work in 64-bit