DatePop builds printable calendars in Excel and puts a real date picker into it. A calendar for any month and a year at a glance are free. For dates, you open the DatePop pane, click a cell, click a date, and DatePop writes a true Excel date into the cell: a date serial with a date format, not text that merely looks like one. The pane stays open and follows your selection, so filling a column of dates is click a cell, click a date, click the next cell, click a date.
Pro adds public holidays for 207 countries, twelve-month and weekly planners, styles, a calendar made from a table of events with an .ics file that imports the same events into Outlook or Google Calendar, fill series and date fields for shared workbooks. You can preview the calendars, the events calendar and the .ics file in the pane before you buy.
DatePop works in Excel on Windows, Mac and the web, needs no macros and no account, and your data stays in Excel. The getting started guide takes you from the sample data to your first picked date in about a minute. The free version is a complete date picker, with date and time, and the month and year calendars, with no time limit and no key.
Coming soon to Microsoft Marketplace. DatePop is not listed yet. The DatePop page shows when it is live, and the steps for adding it are in Installation.
Open the pane once, then leave it open. Excel does not let an add-in open itself or show a popup at a cell, so you open DatePop from the Home tab and keep the pane docked at the side. See Why doesn’t the picker pop up in the cell?
What is in these docs #
- Fundamentals: getting started, installation, plans and licensing, support and the changelog.
- Guides: picking dates into cells, filling a column, adding a time, filling a date series, monthly and yearly calendars, calendars from a list of events, exporting events to Outlook or Google Calendar, date fields for shared workbooks, and language and week settings.
- FAQ: short answers about Mac and Excel on the web, the free version, the missing popup, where the holidays come from and where your data is.
- Troubleshooting: what to do when a date is wrong or shows as a number, the add-in does not load, or a license key is not accepted.
- Account management: activating your license.
Free and Pro #
Every guide says which steps need Pro. Pro features are visible in the free version with a Pro badge, and the calendars, the events calendar and the .ics file preview in the pane, so you can see what they do before you decide. Plans and licensing lists exactly what each version includes.