Pop-up Excel Calendar Short Description:
Date picker that pops up a calendar to allow picking or selecting dates in Excel
Pop-up Excel Calendar Long Description:
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.
This new version added the new option "Date can contain time" that allows you to specify whether Pop-up Excel Calendar works for the dates or formats that contain time. If this option is checked, a date containing time part will be seen as a normal date, the time part is ignored. This option is unchecked by default. As always, all registered users are entitled to upgrade to this version free of charge.