However, when I select the drop down and choose a date, the current time auto populates in there.

How do I remove the time from date and time picker I have managed to put a date/time picker into a cell.

Choose a long date format as shown in the picture below then click OK.

#4 Insert Date and Time from the Design menu.

Select the control in the list and press OK.

Excel 97-2003 Use Insert-Object on the Worksheet Menu Bar.

Note: Read the info good, if you want a solution for all excel versions a custom calendar in a add-in is a better option, check out the links on top of this page for more information. Allerdings erfolgt jetzt der Umstieg von Office 20 und somit ist der Date and Time Picker der in. so langsam bin ich am verzweifeln, für Arbeitszwecke wird eine Excel Tabelle benötigt die per VBA eine Eingabemaske hervorbringt.5- Select the style of the default today's date style and check the Update automatically box. 4- From the Insert tab, select Insert Date and Time. 3- Delete the 'Click here to enter a date.' default text. 2- Select the Design Mode in the Developer Tab. 1- Insert a new date picker content control from the Developer Tab.Unfortunately this control is not 100% reliable and a number of people have decided to make their own. Calendar (Date Picker) Control Alternative When you want to add a calendar to a userform, you can try to make use of the Microsoft Date and Time Picker Control.Click the calendar icon at the right of the Customer Autofilter box. With a filter applied to a column of dates, select Date Filters > Equals. The date picker is in Excel 64 bit - but not available for selection by users for forms, etc.

Microsoft date and time picker excel