Menu

The date picker Excel never had

Click a cell, pick a date. True Excel dates, week numbers and holidays, on Windows, Mac and the web.

Get it free See Pro

Coming soon to Microsoft Marketplace

Excel on Windows, Mac and the web.

A task list and six clicks: the Due date column is filled with real Excel dates, and the pane has moved on to the next cell.

Click a cell, click a date

A task list with the DatePop pane beside it. Six clicks filled the Due date column, and every one of them is a real Excel date.

The Tasks sheet in Excel with the Due date column filled from 11/10/2026 to 11/27/2026 in cells C2 to C7, marked 1, and the selection on C8. In the DatePop pane, the line The next click writes to Tasks!C8, marked 2, sits above the November 2026 calendar, and the Wk column of week numbers 45 to 50, marked 3, runs down its left side. The status says Wrote 27 November 2026 to 1 cell.
  1. Real dates, not textEach cell holds an Excel date, a serial number with a date format, so sorting, filters and formulas work.
  2. The pane follows your selectionIt shows where the next click writes, and the selection moves down after each date, so a column fills with one click per date.
  3. Week numbers in the pickerThe Wk column shows the week number of every row, and the week starts on the day your region uses.

The pane speaks English, German, Spanish, French and Portuguese (Brazil), in a light or a dark theme.

A date picker without the usual workarounds

Excel has no calendar control of its own, and the old fixes come with their own trouble. DatePop is an ordinary Excel add-in.

No ActiveX

The old calendar controls work only in 32-bit Excel for Windows. DatePop does not depend on them.

No VBA, no macros

Nothing to paste into your workbook and no yellow security bar to click away. Your file stays an ordinary .xlsx.

No wrong dates

DatePop writes the date itself, so Excel never has to guess whether 3/4 means March or April.

Mac and the web too

The same pane in Excel for Windows, Excel for Mac and Excel on the web, with Microsoft 365, Excel 2021 and Excel 2024.

A free picker that is complete

Pick into one cell or many, with week numbers and a monthly calendar. No account and no time limit.

Pro stays in sight

Pro features are marked in the pane, and you can preview a Pro calendar before you buy. No nag screens, and no watermark in your workbook.

Week numbers and your region's conventions

Free

The picker shows week numbers, starts the week on the right day for your region and writes dates in your format. Here it runs in German on a German workbook: Monday first, KW for the week numbers, and dates written as 10.12.2026.

A German task list in Excel with the Fällig am column filled with dates such as 01.12.2026 to 10.12.2026, next to the DatePop pane in German: the tabs Datum, Kalender and Mehr, December 2026 with the week numbers KW 49 to 53 and Monday as the first day, and the status 10. Dezember 2026 in 1 Zelle eingetragen.

Rules for shared workbooks

Pro

A date field gives a column its own rules: an earliest and a latest date, no weekends, no public holidays. Everyone who fills in the tracker sees the same rules, and the picker greys out the days that are not allowed. Colleagues on the free version can pick dates into the field too.

A shared tracker in Excel with a Due date field. The cell C9 is selected, and the DatePop pane says Date field: Due date, from 9 November 2026, until 31 March 2027, no weekends. In the November 2026 calendar the weekend days and the days before 9 November are greyed out.

How to use it

Open the pane once. After that, it is a click on a cell and a click on a date.

Open the pane

On the Home tab, click Date picker. The pane opens beside your sheet and stays open.

Click a cell

Select one cell, or a whole range. The pane follows your selection and shows where the next click writes.

Click a date

DatePop writes a real Excel date and, by default, moves the selection down to the next cell.

Calendars you can print

The same pane builds calendars on a new sheet, as plain cells you can edit afterwards.

Monthly calendar Free

Any month on a new sheet, with week numbers if you like and weekends shaded, set up to print on one page.

Export to Outlook or Google Calendar Pro

Turn the rows of an events table into an .ics file that Outlook and Google Calendar can import.

Year at a glance, with public holidays

Pro

Twelve months on one printable sheet, starting in the month you choose, so a school or fiscal year works too. Public holidays for 34 countries are highlighted and listed below the months, and the pane previews the calendar before you insert it.

The sheet Calendar 2027 in Excel with twelve months, ISO week numbers and public holidays highlighted in yellow, next to the DatePop pane on the Calendars tab with Year at a glance selected, January as the start month, 2027 as the year and a preview of the same calendar. The status says Calendar 2027 added as a new sheet.

An events calendar from a table

Pro

Select your table of events, and DatePop builds a month calendar colored by category, with a legend and a marker for events that continue over several days. Change the table and refresh the calendar in place.

The sheet Events Nov 2026 in Excel: a November 2026 calendar with Team kickoff and Quarterly review in blue, Dentist appointment and Family dinner in orange, Thanksgiving in green, a Conference in Lisbon event repeated from Monday to Friday with arrows, and a legend for Work, Personal and Holiday. The DatePop pane shows the detected columns of the events table.

Coming to Microsoft Marketplace

DatePop installs from Microsoft's add-in store, inside Excel. It is on its way and not listed yet.

Once it is listed, this is the whole install:

  1. 1In Excel, go to Home → Add-ins → More Add-ins.
  2. 2On the Store tab, search for DatePop by Bosau Digital.
  3. 3Click Add, open DatePop from the Home tab, then click a cell and a date.
Coming soon to Microsoft Marketplace

Depending on your Excel version, look under Insert → Get Add-ins instead.

  • Windows, Mac and the web
  • No macros, no account
  • Your dates and tables stay in Excel
  • Only the license check sends data

Pay once. No subscription.

The date picker is free. Pro is a lifetime license: you pay once and keep every future update.

A complete date picker, free no account, no card, no time limit

Free
Free
$0
Inside the add-in · no account
  • A complete date picker: one cell or many selected cells
  • Real Excel dates that keep your cell's date format
  • Today, Insert today, month, year and decade views, keyboard
  • Week numbers, first day of the week, 5 languages
  • A monthly calendar sheet for any month
  • Excel on Windows, Mac and the web, light and dark theme
Get it free
Lifetime license
Personal
$19
One-time payment · one person
  • One license key for 3 devices
  • Everything in Free, plus Pro:
  • Date and time, fill series (workdays, every Monday, skip holidays)
  • Public holidays for 34 countries in the picker and the calendars
  • Year at a glance, twelve months, weekly planners and styles
  • Events calendar from a table, and .ics export for Outlook or Google
  • Date fields with rules for shared workbooks
  • Free updates, 14-day money-back guarantee
Lifetime license
Team
$59
One-time payment · your team
  • One license key for 15 devices
  • Everything in Free, plus Pro:
  • Date and time, fill series (workdays, every Monday, skip holidays)
  • Public holidays for 34 countries in the picker and the calendars
  • Year at a glance, twelve months, weekly planners and styles
  • Events calendar from a table, and .ics export for Outlook or Google
  • Date fields with rules for shared workbooks
  • Free updates, 14-day money-back guarantee
  • Excel on Windows
  • Excel on Mac
  • Excel on the web
  • Microsoft 365, Excel 2021 and Excel 2024

Frequently asked questions

No. Excel does not let an add-in place a pop-up at a cell, so DatePop works in a pane beside your sheet. Open it from the Home tab, and it follows your selection: click a cell, then click a date. Add-ins installed from Microsoft Marketplace cannot open a pane by themselves, so you open it yourself, for example with the Date picker button on the Home tab.
Real dates. DatePop writes an Excel date, a serial number with a date format, so sorting, filtering, formulas and PivotTables work. A cell that already has a date format keeps it. Nothing is typed as text for Excel to interpret, so a 3/4 never turns into the wrong month.
The free version is a complete date picker, with no account: pick a date into one cell or into many selected cells, Today and Insert today, month, year and decade views, week numbers, the first day of the week for your region, the keyboard, a light and a dark theme, five languages, and a monthly calendar on a new sheet for any month. There is no row limit and no time limit.
Pro adds the date and time picker, fill series (workdays, every Monday, the second Tuesday, skipping holidays), public holidays in the picker and the calendars, a year at a glance, twelve months and weekly planners with styles, an events calendar from a table, an .ics export for Outlook and Google Calendar, and date fields with rules for shared workbooks. Pro features are visible in the free version, marked Pro, and you can preview a Pro calendar in the pane before you buy.
Yes. DatePop runs in Excel for Windows (Microsoft 365, Excel 2021 and Excel 2024), Excel for Mac and Excel on the web. It installs from Microsoft Marketplace, where it is coming soon, or through your admin. There is no separate installer to download.
No. DatePop is an Office add-in. There is nothing to paste into your workbook, no macros to enable, and your file stays an ordinary .xlsx. The old ActiveX calendar controls work only in 32-bit Excel for Windows, and DatePop does not depend on them.
The pane speaks English, German, Spanish, French and Portuguese (Brazil), and follows your Excel language by default. With Pro, the month and day names of a calendar can use a different language than the pane.
Pro includes public holidays for 34 countries, and for regions where the data has them, such as US states, German states, Swiss cantons and Spanish communities. They show in the picker and in the calendars. The data is bundled with DatePop from the open-source date-holidays project and loads from the same address as the add-in, so no holiday web service is called. Where the holidays come from is explained in the documentation.
With Pro, DatePop turns the rows of your events table into an .ics file that Outlook and Google Calendar can import. In Excel on the web the file downloads directly. On Windows and Mac, DatePop opens a page in your browser that saves the file. The events travel in the part of the web address after the # sign, which a browser never sends to a server, so nothing is uploaded.
No. A workbook with date fields made with Pro works for a colleague on the free version: they can pick dates into the fields, and the rules apply to them as well. Creating or editing date fields is the Pro part.
No. Dates, selections and tables are read and written inside Excel, on your device, and nothing from your workbook is sent anywhere. The only request that carries data is the license check, which happens only once you add a license key. It sends the license key, a random install ID, the app version and a short platform name such as "Excel for Windows". The details are in the privacy policy.
It is a one-time license with no subscription. Personal covers one person on up to 3 devices, and Team covers up to 15 devices. Both unlock every Pro feature and include future updates. You enter the key from your purchase email in the pane menu, and you manage your devices in your account. If it is not for you, email me at contact@pythonandvba.com within 14 days and you get your money back. The full policy is at pythonandvba.com/refund-policy.
Sven Bosau

Still have a question?

I’m Sven, the developer, and I usually reply within a day.

Please enter your first name.

Please enter a valid email address.

Please write a little more (at least 10 characters).

Your email is only used to reply. No newsletter. How I handle your message: Privacy Policy.

Fill a column of dates in a minute.

DatePop is on its way to Microsoft Marketplace. The free version will be a complete date picker, with no account.

Get it free

DatePop is an independent product by Bosau Digital LLC. It is not affiliated with, endorsed by or sponsored by Microsoft. Microsoft and Excel are trademarks of the Microsoft group of companies.