BoostExcel main content
Excel Date Picker (Pop Excel Calendar) screenshot

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!

Pop-up Excel Calendar screenshot
Pop-up Excel Calendar screenshot (Settings)

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...

Two flavors

Now Pop-up Excel Calendar / Date Picker for Excel has a Microsoft Store edition too.

 Traditional Desktop EditionMicrosoft Store Edition
 Desktop Edition iconMicrosoft Store Edition icon
How to installDownload from the product page and then run the setup program Install from Microsoft Store
Installation modeThe add-in is installed to the machine. All user accounts logged into Windows can use the app.The store app is installed for the current user account.
How to useOpen 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 to all Excel files.

LicensingLife time license.

Each computer requires its own license.

Subscribe from Microsoft Store.

One subscription allows to install the app on up to 10 devices.

Prices19.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

Windows 10

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.