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!

Excel Date Picker (Pop Excel Calendar) screenshot

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!

Pop-up Excel Calendar screenshot

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

Pop-up Excel Calendar screenshots (Settings)

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 StoreMicrosoft Commercial MarketplaceTraditional Installation

Get it

Manage: Microsoft account

Get it

Download

Manage: Microsoft 365 admin center

Get it

Download

This table further details the differences between the store edition and the traditional edition:

 Traditional EditionMicrosoft Store Edition
 traditional edition iconMicrosoft Store Edition icon
How to installDownload and then run the setup program.Install from Microsoft Store.
Installation modeThe 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 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 for all Excel files.

LicensingLifetime license.

Each computer requires its own license.

Subscribe from Microsoft Store.

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

Prices19.5 USD for a single lifetime license (one computer only)0.99 USD/month

The prices may vary in different countries or markets.