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.
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). Result: the cells are formatted as dates.
- Double-click a cell. Result: a calendar appears next to the cell.
- Pick a date, changing the month or year if needed. Result: the date fills the cell in the format you chose.
A Microsoft support agent gave the same steps on Microsoft Q&A in November 2025. The calendar doesn’t appear in desktop Excel, even when the same file is opened there.
Add a Date Picker Add-in (Desktop Excel)
Microsoft’s support team recommends the add-in route 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. Result: the Office Add-ins window opens.
- Search for date picker and choose an add-in like Mini Calendar and Date Picker.
- Select Add and accept the permissions. Result: the add-in opens in a pane on the right.
- Click a cell, then pick a date in the add-in. Result: the date fills the cell. Next time, open it again from Home › Add-ins.
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. Ablebits notes 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.
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. Result: Excel shows an error if someone types anything that isn’t a date in that range.
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, see how to remove data validation in Excel.
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?
Not as of October 2026. 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.
Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read hundreds of millions of times.
After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.
His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.