What Is Excel Date Picker
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, 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 cannot perform calculations with the 'so-called' dates. It also means any charts, Pivot tables, etc. based on 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 2013 to Microsoft 365, both 64-bit and 32-bit.
- Not only "Normal" View
Pop-up Excel Calendar works not only in Excel's normal view but also in split mode and frozen mode. The date picker works even if the zoom is not 100%.
- Flexibility
Recognize cells that contain date values, formatted as date, underneath the word "Date", etc. Show several months in width and height; show week numbers,...
Download and Subscribe
How do I choose?
Choose Microsoft Store if you use a Microsoft account, choose Microsoft Commercial Marketplace if you use a work or school account. Learn more.
Microsoft Store | Microsoft Commercial Marketplace | Traditional Installation |
---|---|---|
This table further details the differences between the store edition and the traditional edition:
Traditional Edition | Microsoft Store Edition | |
---|---|---|
How to install | Download and then run the setup program. | Install from Microsoft Store. |
Installation mode | The add-in is installed on the machine. All user accounts logged into Windows can use the app. | The store app is installed for the current user account. |
How to use | Open any Excel file. | Run the Date Picker for Excel app once to install the add-in. Once the add-in is installed, the date picker is available for all Excel files. |
Licensing | Lifetime license. Each computer requires its own license. | Subscribe from Microsoft Store. One subscription allows you to install the app on up to 10 devices. |
Prices | 19.5 USD for a single lifetime license (one computer only) | 0.99 USD/month The prices may vary in different countries or markets. |