What Is Excel Date Picker (Pop-up Excel Calendar)
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!
Why you need it
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!
What makes our datepicker unique
All Major Excel Versions
Excel Date Picker works with all major Microsoft Excel versions on Windows, from Excel 2007 to Excel 2019, both 64-bit and 32-bit.
Not only "Normal" View
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...
Now Pop-up Excel Calendar / Date Picker for Excel has a Microsoft Store edition too.
|Traditional Desktop Edition||Microsoft Store Edition|
|How to install||Download from the product page and then run the setup program||Install from Microsoft Store|
|Installation mode||The add-in is installed to the machine. All user account log into Windows can use the app.||The store app is installed for the current user account.|
|How to use||Open any Excel file||You should first start the Date Picker for Excel app. |
Once it is running (even in the background or minimized to the system tray), the date picker is activated in all the Excel files you open.
|Licensing||Life time license. |
Each computer requires its own license.
|Subscribe from Microsoft Store. |
One subscription allows to install the app on up to 10 devices.
|Prices||19.5 USD for a single life-time license (one computer only)||1.99 USD / month |
The prices may vary in different country / market.
Microsoft Windows 10/8/7
Microsoft Excel/Office 2019 -- 2007
Microsoft Excel 2019 -- 2010
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 online Office subscriptions that runs purely inside a web browser.