Add a Date Picker in Excel for Mac Without the Windows Developer Control
Question details
The user needs to insert a date picker in Excel for Mac, but the Developer tab does not show the Windows Date and Time Picker control because the Windows ActiveX component is not compatible with Excel for Mac.

- Product
- Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- Creating or editing a workbook in Excel for Mac where a clickable calendar date picker is needed for easy date entry.
- Observed behavior
- Excel for Mac does not show the Windows Developer tab Date and Time Picker control because the control is an ActiveX component and is not compatible with Excel for Mac.
Make sure you are running the latest version of Excel for Mac and are signed in with a Microsoft account so the Office Add-ins store is available before you add a date picker.
Install a Mac-Compatible Date Picker from the Office Add-ins Store
Use this when you want a clickable calendar control similar to the Windows date picker without writing code.
The Windows date and time picker control is an ActiveX component that Excel for Mac does not support. The Office Add-ins store contains calendar add-ins that run on macOS and provide the same interactive date selection.
In Excel for Mac, open your workbook and click the Insert tab, then select Get Add-ins or Add-ins.
Type “date picker” or “calendar” in the search box, select a Mac-compatible add-in such as a calendar pop-up, and click Add or Open.
Follow the add-in instructions to insert the calendar control into the worksheet, then click a cell to select a date from the pop-up.

Create a Data Validation Date Field as a No-Add-In Alternative
Use this when you cannot install add-ins and you want to restrict cell entries to valid dates.
Use a Custom VBA Calendar Form Built for macOS
Use this if you need a fully custom date picker and are comfortable enabling macros.
Use WPS Office for Mac as a Free Excel Alternative for Date-Entry Workbooks
Because the missing Developer date picker is a Microsoft Excel for Mac limitation, WPS Office offers a free, lightweight Office alternative on macOS. It opens and saves Excel workbooks with strong format compatibility and a familiar spreadsheet interface, so you can keep working without relying on Windows ActiveX controls.
- 1. Download WPS Office for Mac: Go to the official WPS Office website and click Download WPS Office Free, then choose the macOS version.
- 2. Install and launch WPS Office: Open the downloaded installer, drag WPS Office to the Applications folder, and launch WPS Office.
- 3. Open your Excel workbook: In WPS Office, click Open and select your existing Excel file to continue working with its data and formatting.

Frequently Asked Questions
Why doesn’t Excel for Mac show a date picker in the Developer tab?
The Windows date and time picker control is an ActiveX component, and Excel for Mac does not support ActiveX controls. That is why the Developer tab does not show the same Insert command you see in Excel for Windows.
Can I use the Windows ActiveX date picker in Excel for Mac?
No. The Windows ActiveX date picker is not compatible with Excel for Mac. You need a Mac-compatible add-in, a data validation date field, or a VBA solution that supports macOS.
Is there a free date picker add-in for Excel for Mac?
Yes. Open Excel for Mac, go to the Insert tab, choose Get Add-ins or Add-ins, and search for “date picker” or “calendar.” Many calendar add-ins are free or offer a free tier, but check the add-in listing for any licensing limits.
Can I add a date picker without installing an add-in?
You cannot add the Windows-style pop-up calendar without an add-in, but you can use Data Validation on the Data tab to restrict cells to valid dates or create a macOS-compatible VBA UserForm for a custom date entry experience.




