Insert Drop Down Calendar In Excel 2013
Then draw the drop down list calendar to the worksheet where you want it to appear and resize the box with dragging its corner.
Insert drop down calendar in excel 2013. The good news is that the excel team is currently working to add datetime picker officially in all versions of excel by this source. The built in datetime picker in excel only exists in the 32bit version of excel. Select microsoft date and time picker control 6 0 sp6 from the list.
The drop down calendar can significantly minimize the data entry errors for dates. In the more controls dialog just select microsoft date and time picker control 6 0 and then click the ok button. Then click developer insert more controls.
If you have the 64bit version of excel you may try some third party tools mentioned on the same page.