Excel Date Picker

MVPromise ,,,

To get the Date Picker do the following:

1. Hit the Developer Tab , find & click Design, and next to it is Insert.
2. From Control at Right bottom find More Control.

1. Find Microsoft Date & Time Picker Control, version 6.

1. Select it & finish with Ok.
2. Now Insert the Date Picker on Sheet.
3. Right click it, & hit properties.
4. Find, Linked Cell and insert cell reference in which you want to store Date.
5. 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.