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 2007. 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.
With this new version, the date picker offers a new option that enables the pop-up calendar to show a default date for a target cell.