How to Insert Date Picker control in O365 Excel

New Contributor

Anyone can explain How to Insert Date Picker control in O365 Excel

5 Replies



Doesn't the calendar control also work?

The control element "Microsoft MonthView Control 6.0 (SP4) can also not be found under other controls. The nice thing about the Date and Time Picker is that you can provide a date input field with little effort, which always delivers a date as the result.

Display the form in the VB editor;

under Extras / Additional Controls ... check the entry 'Microsoft Date and Time Picker Control';

Drag the new 'DTPicker' icon from the toolbox into the form.


Insert a date picker


Which Excel version of 365 do you have? ... and which operating system? ... if it doesn't work

and you would like to give us feedback (which I would be happy, especially if it works please specify.


Thank you for your patience and time.



I know I don't know anything (Socrates)


* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

Thank You. My version O365 16 x32 bit
Windows 10 Business


For Windows platform it's coming, you may add your vote here Add 'date picker' to enable users to select a date from a mini calendar into cells  Not sure about other platforms (365 Online, Mac, Android, iOS).


Alternatively you may google for third-party solutions, have no experience with them and don't know if they are reliable or not.



This may prove helpful to you:


If you have a 32 bit version of Office then it's still possible for you to use the DT Picker.  If not, Microsoft doesn't appear to currently support it in the 64 bit version of Office unfortunately.