Office for Mac Issues

Add a Date Picker in Excel for Mac Without the Windows Developer Control

Natalie TaylorNatalie Taylor Nov 13, 2026 868 views

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.

How to Add a Date Picker in Excel for Mac Without the Windows Developer Control
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the Add-ins store

In Excel for Mac, open your workbook and click the Insert tab, then select Get Add-ins or Add-ins.

2
Search for a calendar date picker

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.

3
Insert the date picker

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.

Install a Mac-Compatible Date Picker from the Office Add-ins Store
Recommended solution: This is the closest built-in, no-code replacement for the missing Windows ActiveX date picker on Excel for Mac.
Free Microsoft Office alternative

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. 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. 2. Install and launch WPS Office: Open the downloaded installer, drag WPS Office to the Applications folder, and launch WPS Office.
  3. 3. Open your Excel workbook: In WPS Office, click Open and select your existing Excel file to continue working with its data and formatting.
Avoids Excel for Mac ActiveX control limits with a Mac-friendly spreadsheet environmentOpens and saves .xlsx and .xls files with Microsoft Office format compatibilityFree, lightweight, and easy to use on macOSFamiliar ribbon and workbook interface for a seamless migration from ExcelNo paid add-ins required for common date-entry and spreadsheet tasks
microsoft office alternative - wps office

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.