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.
- Works silently in the background.
- Detects date cells automatically
Features: Everything You Need. Nothing You Don't.
Built specifically for Excel, Pop-up Calendar fits naturally into your workflow without getting in the way.
Works automatically
The add-in detects date cells and shows a small icon button next to them. No manual activation — it just appears when you need it.
Multi-month calendar
Display up to 10 × 10 months at once for easy navigation across date ranges. Perfect for project planning and scheduling.
Fully Customizable Calendar Styles & Colors
Match the calendar to your spreadsheet style. Choose custom colours for the border, background, title bar, and trailing dates, or save presets.
Right-Click Shortcut Menu Integration
Access the pop-up calendar instantly by right-clicking any cell in your spreadsheet, keeping your workflows fluid without reaching for the Ribbon bar.
Flexible Triggers
Toggle the date picker to display automatically whenever an empty date field is targeted, or prompt it on demand using your custom Ribbon tab toolbar button.
Robust Support for International & Custom Formats
Overcome regional settings issues. Easily whitelist or blacklist specific custom Excel date format codes through the options panel to guarantee reliable date insertion globally.
Smart date detection
Recognises date cells by format code, cell value, or column heading — in over 50 languages. The right cells light up every time.
Week numbers
Display ISO week numbers on the calendar. Configure the first day of the week to match your locale — Sunday, Monday, or any other day.
50+ language support
The "date column" detector understands the word for "date" in over 50 languages, so it works in any regional Excel installation.
Auto date formatting
Optionally apply your preferred date format to any cell that doesn't have one yet. Maintain consistency across the whole spreadsheet automatically.
Ribbon integration
Install as a dedicated "Pop-up Calendar" ribbon tab, or as a compact group within Excel's Insert tab — whichever suits your workspace.
Enable / disable instantly
Toggle the calendar on or off with a single ribbon button. It stays installed but stays out of your way whenever you need it to.
Smart Automation: Auto-Detect Date Fields & Columns
You never have to tell Pop-up Calendar where your date columns are. It figures that out on its own, using four independent signals.
Date format code
If a cell is already formatted as a date (e.g. dd/mm/yyyy), the calendar icon appears immediately when you click it.
Date-like value
If a cell contains a number that looks like a date — even without a date format applied — the icon still appears.
Cell below a date
Filling in consecutive date rows? The icon appears in empty cells directly below a cell that already has a date value.
Column heading
If the cell above contains the word "date" in any of 50+ supported languages, any cell in that column activates the picker.
Settings: Your Calendar, Your Way.
- Calendar layout
Choose how many months appear at once — from 1×1 to multi-month grids — and how many past months to show by default.
- Custom colour presets
Save your favourite colour combinations as named presets and switch between them instantly.
- Default date
Set a specific date for the calendar to open on when a cell is empty — useful for scheduling templates.
- Custom date format overrides
Mark specific Excel format codes as always valid or always invalid — useful for unusual regional formats that confuse the automatic detector.
- Right-click menu
Optionally add a "Pop-up Calendar" entry to the Excel cell right-click context menu for quick keyboard-free access.
Download and Subscribe
How do I choose?
- Choose Microsoft Store if you use a Microsoft account—usually for personal usage.
- Choose Microsoft Marketplace if you use a work or school account—usually for business and enterprise usage.
| Microsoft Store | Microsoft 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. |
| License Terms & Devices | Lifetime Excel Add-in License. Each computer requires its own license. | Microsoft Store Subscription / Microsoft Marketplace Subscription. One subscription allows you to install the app on up to 10 devices. |
| Excel Add-in Pricing | 19.5 USD for a single lifetime license (one computer only) | 0.99 USD/month The prices may vary in different countries or markets. |
System Compatibility:
- Supported Host PlatformsMicrosoft Excel 365, Excel 2021, Excel 2019, Excel 2016, Excel 2013
- Architecture SupportFully compatible with both 32-bit and 64-bit Excel installations on Windows 11 and Windows 10 environments.
