Adding Date Picker in Excel

This is how to add datepicker in excel for selecting the date from Calender.


- In sheet, right click, and tool bar entry points
- Date difference calculator while you mouse over the different days
- Options to turn on and off entry points and appearance


Installation steps
- unzip the XLA to your XLSTARTUP folder, it's located in the Microsoft office directory: C:\Program Files\Microsoft Office\OFFICE11\XLSTART
- Restart Excel



Calendar F.A.Q. ...answers to questions you're probably thinking about right now!

What's this for and how does it work?
Useful for people who use dates in Excel. Allows you to see a calendar view and pick from it to change a cell's value.

What Version of Excel do I need for this to work?
Should work back to at least Excel 2000, maybe even before.

Where are all the entry points to the calendar?
There are 3 places where you can access the calendar from: right click menu, on the tool bar, and particular cell selections which include: selecting a cell with a date in it, selecting a cell underneath a cell with a date in it, and selecting a cell underneath a cell that has some form of the word "date" in it. You can adjust the entry points in the options menu accessible on the upper right hand corner of the calendar.

Download The File samradDatePicker.xla


Courtesy : http://www.isamrad.com