Pop-up Excel Calendar is an Excel add-in program that allows you to easily enter dates into Excel with a few mouse clicks.
For a quick example, click your mouse on a cell in which you must enter a date. An in-cell icon button appears. Click the icon button to display the calendar. Click the date you want to enter and you are done!
Pops up the calendar whenever needed - for cells that have date values, date formats, underneath date values, formats or certain labels.
Applies user-defined date format to target cells if needed; Shows or hides week numbers, or even shows several months on the calendar.
Once installed, it works for any Excel workbooks on this computer. No macros, no security concerns, no modifications to your Excels files.
One of the common problems many users encounter with Excel is incorrectly entering dates. People seem to get confused about entering dates. Should they enter dd/mm/yy or mm/dd/yy? Do they enter slashes or dashes or dots? And what was the date of the third Thursday in September last year anyway?
When a date is not entered in the correct format Excel will not recognize it as a valid date. This often means you can not perform calculations with the 'so-called' dates. It also means any charts, Pivot tables etc based off the dates will not be valid.
What you really need is Pop-up Excel Calendar, or a date picker running right within Microsoft Excel!
Excel Date Picker works with all major Microsoft Excel versions on Windows - Excel 2007, Excel 2010, Excel 2013 and Excel 2016, both 64-bit and 32-bit.
Pop-up Excel Calendar works not only in Excel normal view, but also split mode and frozen mode. The datepicker works even if the zoom is not 100%.
Recognize cells contain date value, formatted as date, underneath the word "Date", etc. Show several months in width and height, show week numbers...
The date picker for Excel supports both 32-bit and 64-bit of Excel and Windows.
Note it requires the standalone (locally installed) desktop version of Excel / Office. For now it does not work with Office 365 subscriptions that runs purely inside a web browser.