Calendars and a date picker for Excel
Print a month or a whole year at a glance for free, and click a date into any cell. The picker works the same in Excel on Windows, Mac and the web.
Listed on Microsoft Marketplace. Excel on Windows, Mac and the web.
A year at a glance in one click: twelve months on a printable sheet, with week numbers. Free in the Clean style; Pro adds holidays and styles.
Calendars you can print
The same pane builds calendars on a new sheet, as plain cells you can edit afterwards. A month and a year at a glance are free.
Monthly calendar Free
Any month on a new sheet with 1 to 5 rows per day (the date plus up to four rows to write in), 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. The free version previews the events before you buy.
Year at a glance
FreeTwelve months on one printable sheet, starting in the month you choose, so a school or fiscal year works too. The pane previews the calendar before you insert it. Pro adds public holidays for 207 countries, highlighted and listed below the months as in this picture, and the styles.
An events calendar from a table
ProSelect 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. Everyone can preview it from their own table before buying.
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.
- Real dates, not textEach cell holds an Excel date, a serial number with a date format, so sorting, filters and formulas work.
- 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.
- 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 on the web has a basic date picker of its own. Excel for Windows and Mac have none built in, and the old fixes come with their own trouble. DatePop is an ordinary Excel add-in with the same picker everywhere.
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 and free calendars
Pick into one cell or many, with week numbers, and print a month or a year at a glance. No account and no time limit.
See Pro before you buy
Pro features are marked in the pane, and the Pro calendars, the events calendar and the .ics file preview there. No nag screens, and no watermark in your workbook.
Week numbers and your region's conventions
FreeThe 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.
Rules for shared workbooks
ProA 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.
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.
Installed in about a minute
Straight from Microsoft's add-in store, inside Excel. No installer file, no macros and no account. The free version is a date picker with month and year calendars.
- 1In Excel, go to Home → Add-ins → More Add-ins.
- 2On the Store tab, search for DatePop by Bosau Digital.
- 3Click Add, open DatePop from the Home tab, then click a cell and a date.
Listed on 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 and the printable calendars are free. Pro is a lifetime license: you pay once and keep every future update.
- The date picker, for one cell or many
- Real Excel dates, with date and time
- A month calendar and a year at a glance
- Week numbers and 5 languages
Everything in Free, plus:
- 1 person, up to 3 devices
- Public holidays for 207 countries
- Twelve-month and weekly calendars, styles
- Events calendar and .ics export
- Fill series and date fields
Everything in Single, plus:
- Your whole team, up to 15 devices
- All with one license key
- Excel on Windows
- Excel on Mac
- Excel on the web
- Microsoft 365, Excel 2021 and Excel 2024
Frequently asked questions
Still have a question?
I’m Sven, the developer, and I usually reply within a day.
Print a calendar. Fill a column of dates.
Add DatePop to Excel from Microsoft Marketplace. The free version includes the date picker and printable calendars, with no account.
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.