How to Add a Pop-Up Calendar to a Cell in Excel

In Excel for the web, a calendar pops up automatically when you double-click a cell formatted as a date. Desktop Excel has no built-in pop-up calendar, so add a free date picker add-in: go to Home › Add-ins (or Insert › Get Add-ins), search for “date picker,” and add one such as Mini Calendar and Date Picker. The old Microsoft Date and Time Picker Control works only in 32-bit Excel, and most Microsoft 365 installs are 64-bit.

This guide covers the built-in date picker in Excel for the web, date picker add-ins for desktop Excel on Windows and Mac, the legacy 32-bit control, Data Validation to block non-dates, and quick date shortcuts. Details come from Microsoft’s Excel blog and Microsoft Q&A, checked October 1, 2026.

Table of Contents show

Illustration comparing ways to get a pop-up calendar in an Excel cell — Illustration: the ways to get a pop-up calendar in an Excel cell, and which versions each works in.

Use the Built-In Date Picker in Excel for the Web

Microsoft added a Date Picker to Excel for the web in its January 2024 update. It says the pop-up is enabled automatically when a cell is formatted as a date or already contains a date.

Open the workbook in Excel for the web (office.com or OneDrive).
Select the cells, then choose Home › Number Format › Short Date (or Long Date). The cells are formatted as dates.
Double-click a cell. A calendar appears next to the cell.
Pick a date, changing the month or year if needed. The date fills the cell in the format you chose.

Excel for the web calendar date picker open next to a date cell — Double-click a date-formatted cell in Excel for the web to open its calendar. This example shows October 2026 with the 15th selected.

The calendar doesn’t appear in desktop Excel, even when you open the same file there.

Add a Date Picker Add-in (Desktop Excel)

Microsoft recommends add-ins for 64-bit Excel in this Microsoft Q&A answer. Add-ins work in Excel for Windows, Mac and the web.

Open your workbook.
Select Home › Add-ins, or Insert › Get Add-ins in some versions. The Office Add-ins window opens.
Search for date picker and choose an add-in like Mini Calendar and Date Picker.

Recreated shared Office Add-ins Store detail with Datepicker in search, Mini Calendar and Date Picker listed and Add highlighted — Search the Store for a date picker and select Add for the add-in you choose. This recreated shared Store detail uses the verified Mini Calendar and Date Picker by Vertex42 and the example query Datepicker. Ratings, other results and the rest of the dialog are outside the detail; store layout and availability vary.

Select Add and accept the permissions. The add-in opens in a pane on the right.
Click a cell, then pick a date in the add-in. The date fills the cell. Next time, open it again from Home › Add-ins.

Recreated Excel sample worksheet with B2 selected containing October 23 2026 and a Vertex42 style embedded October 2026 calendar at right, date 23 highlighted — Select a cell, then choose a date in the add-in’s calendar. This recreated Mini Calendar and Date Picker example shows its embedded worksheet calendar and 10/23/2026 in B2; this add-in is not a right-hand task pane. Other date pickers may use a pane. The calendar and sample date are illustrative.

Illustration of adding a date picker add-in in Excel: Home, Add-ins, search date picker, Add, then click a cell and pick a date — Illustration: adding a date picker add-in in desktop Excel.

Add-ins are made by other companies, so read the permissions and reviews first. If your workplace blocks add-ins, ask your IT team. Some add-ins need an internet connection to load.

The Old Date and Time Picker Control (32-bit Only)

Many older guides tell you to add the Date Picker from Developer › Insert › More Controls and choose Microsoft Date and Time Picker Control. This ActiveX control works only in 32-bit Office. To check your version, go to File › Account › About Excel and look at the top line for 32-bit or 64-bit. There’s more on finding which version of Excel you have.

If you do have 32-bit Excel, the control still needs the Developer tab (right-click the ribbon › Customize the Ribbon › check Developer), Design Mode to place it, and a linked cell to store the date. It doesn’t work on Mac or the web, so files shared with others may not show it.

Mac users can still show the Developer tab in Excel for Mac for form controls such as buttons and check boxes.

Make Sure Only Dates Can Be Entered

If you mainly want to stop typos, Data Validation is built in and works in every version. It doesn’t show a calendar, but it rejects anything that isn’t a date. Microsoft covers it in Apply data validation to cells.

Select the cells.
Go to Data › Data Validation.
Under Allow, choose Date.
Set a range, such as between 1/1/2026 and 12/31/2026, and select OK. Excel shows an error if someone types anything that isn’t a date in that range.

Recreated Excel Data Validation Settings dialog with Allow Date, Data between, Start date January 1 2026, End date December 31 2026 and OK highlighted — On Data Validation’s Settings tab, choose Date and between, then enter the earliest and latest allowed dates. This recreated example allows 1/1/2026 through 12/31/2026. Select OK to apply the rule; Data Validation restricts entries and does not add a pop-up calendar.

On the Input Message tab, you can add a note like “Enter a date as MM/DD/YYYY” that appears when someone selects the cell. To remove the rule later, clear the data validation in Excel.

Once a column holds real dates, you can sort it by date in Excel Online with one click.

With birthdates stored as real dates, you can also calculate age from a birthdate in Excel with one formula.

Quick date shortcuts

Ctrl + ; enters today’s date.
=TODAY() shows today’s date and updates every day.
Dragging the fill handle down from a date fills in the next days.
For a fixed set of choices instead of dates, add a drop-down list in Excel.

Troubleshooting

No calendar in Excel for the web: make sure the cell is formatted as a date, then double-click it rather than single-clicking.
Add-ins button is missing or grayed out: your organization may block add-ins, or you may be signed out of your Microsoft account.
Date Picker control isn’t in More Controls: you’re probably on 64-bit Excel. Use an add-in instead.
The date shows as a number: format the cell as a date with Home › Number Format.

Frequently Asked Questions

Does desktop Excel have a built-in date picker?

No. The built-in pop-up calendar is in Excel for the web only. Desktop Excel needs an add-in, or the 32-bit control.

Will a date picker add-in work for other people who open my file?

Usually only if they install the same add-in. The dates themselves are normal cell values, so everyone can see them.

Can I use VBA for a pop-up calendar?

Yes, with a custom UserForm, but it requires saving as a macro-enabled .xlsm file and enabling macros, and it doesn’t run in Excel for the web.

If you need a printable monthly calendar rather than a date picker, make a calendar in Word instead.

<p>For any calendar that relies on VBA, you will also need to know <a href=”https://www.solveyourtech.com/enable-macros-excel/”>how to enable macros in Excel</a> safely.</p>

Matthew Burleigh

Matthew Burleigh is the founder, head writer, and editor of Solve Your Tech, which he launched in 2012. He has written technology tutorials since 2008 and worked in IT since 2003, including small-business support, IT management, and consulting. He holds Bachelor’s and Master’s degrees in Computer Science from Arizona State University.

Matthew writes practical guides for Windows, iPhone and iPad, Microsoft Office, Outlook, Google apps, and Android. Solve Your Tech’s guides are checked step by step against the device or app maker’s own documentation and tested on his own devices whenever he has the hardware or software, with clear steps, sources, and update dates.

Read more about Matthew and how Solve Your Tech writes and updates its guides, or report a correction.