Updated October 17, 2026
Need a calendar you can click instead of typing dates? Start with the version of Excel you're using. Excel for the web has a built-in date picker. Desktop add-ins and older calendar controls are separate options with different requirements.
Choose your starting point
Excel for the web, on Windows or Mac: Try the built-in calendar below. There is no date-picker add-in to install.
Excel for Windows desktop: If you want an add-in, see the Rad Sheets Date Picker and its installation guide. Check compatibility with your Excel version and your organization's macro policy first.
Excel for Mac desktop: Use the date-validation setup below for date entry, or use Excel for the web when you want its built-in calendar. Check explicitly for Mac support before choosing a desktop calendar add-in.
Open the built-in calendar in Excel for the web
Open an editable workbook in Excel for the web.
Select a blank cell and give it a date format from the Home tab's number-format menu. You can also use a cell that already contains a date.
Double-click the cell, then choose a date from the calendar.
Microsoft announced this behavior on January 30, 2024: the picker is enabled for date-formatted cells or cells containing a date value. That announcement describes the web version; it is not a desktop add-in installation guide. Microsoft's date-picker announcement
Use the Rad Sheets add-in in desktop Excel
The Date Picker page has the download, installation link, and customization details. The add-in adds a ribbon button, with optional right-click and in-cell entry points.
Start in a spare workbook. Follow the linked installation instructions, select a test cell, open the picker from its ribbon button, and choose a date. Check the result before using it in a working file.
The download uses VBA. Excel for the web cannot run VBA macros, so uploading the add-in or a macro-enabled workbook does not make its picker run in a browser. Use the web calendar above there. Microsoft's VBA guidance
Limit dates on Windows, Mac, or the web
A calendar helps you select a date. Data validation helps restrict which dates you enter. For a simple 2026 tracker:
Select the entry cells, such as B2:B20, and choose Data → Data Validation.
Choose Date, then between.
Set the start date to January 1, 2026, and the end date to December 31, 2026, using the date format Excel expects in your region.
Add a helpful input message and a Stop error alert. Test by typing an allowed date and an out-of-range date.
This is useful without an add-in. It does not promise a calendar pop-up in every Excel client. Microsoft documents date validation for Windows, macOS, and the web. Data-validation instructions
Quick troubleshooting
No calendar in the browser? Try a fresh blank cell, apply a date format, and double-click it. Check that you're editing in Excel for the web rather than viewing a file preview.
The desktop add-in is blocked? Downloaded macro-enabled add-ins can be blocked by Windows' Mark of the Web or organization policy. Verify the source and follow approved installation guidance; don't turn on all macros just to make a calendar work. Microsoft's explanation
An older tutorial asks for an ActiveX calendar? ActiveX controls are a separate technology; don't assume those instructions apply to this VBA add-in. Microsoft says ActiveX is disabled by default in Microsoft 365 and Office 2024, and is unsupported on Mac and the web. ActiveX defaults, platform support
The cell shows #####? Widen the column. If the date displays in an unexpected order, check its date format and regional settings. Date formatting
For the add-in's options and download, continue to the Rad Sheets Date Picker.