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 customisable colours
Match the calendar to your spreadsheet style. Choose custom colours for the border, background, title bar, and trailing dates, or save presets.
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: It knows when you need it.
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, choose Microsoft Marketplace if you use a work or school account. Learn more.
| 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. |
| 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. |
