Skip to main content main content
Sharing is caring


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!

Excel Date Picker (Pop Excel Calendar) screenshot


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.


Why you need it?

Pop-up Excel Calendar screenshot

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 - Excel 2007, Excel 2010, Excel 2013 and Excel 2016, 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...

Pop-up Excel Calendar screenshot (Settings)



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.