Selecting a date in the calendar inserts a different formatted date into each text box. Clicking the Insert date button inserts the formatted date from the top text box into the worksheet.

Macro to create Date Picker Excel 2003 had a feature “Date Time Picker”. Date time picker was a GUI way of selecting a date in excel, but from Excel-2007 onwards for some weird reason the feature was ...