Pop-up Excel Calendar is an Excel date picker
Excel date picker is a completely redesigned version of pop-up excel calendar. It now supports all the new windows and excel versions, both 64 and 32 bit. There are also a number of interesting features and options added to the program. For example, you can tell the date picker to show the calendar 2 months in width and 1 month in height.
New options in excel date picker include calendar background color, calendar border color and showing week numbers. Pop-up excel calendar is a date picker for microsoft excel. It runs inside excel and when you activate a cell where a date value muse be entered, it pops up a calendar to let you pick or select a date from the calendar, instead of typing in manually.
This helps you save time and avoid common mistakes found in working with date values. For example, should you enter dd/mm/yy or mm/dd/yy? Do you enter slashes or dashes or dots? Pop-up excel calendar detects date cells based on various conditions, including the format or value of the active cell, the label or format of the above cell, etc.
All these are configurable.
If a date cell is detected, an in cell icon button appears, which you can click to pop up the calendar to pick or select a date value
Or, you can set an option to have the calendar pops up automatically
Besides that, you can also activate the calendar manually on any cell by selecting the command from toolbar, context menu, and ribbon tab in excel 200
Pop up excel calendar offers options to let you decide where to add the calendar command
The date picker also provides other useful options
For example, you can set the first day of week option to adjust the calendar layout; set the default date format option to have the calendar set a date format if the target cell is not formatted as date
With custom formats, you can even control what formats are valid date formats and what are not