Install or Replace the Date Picker ActiveX Control in Excel 365
Question details
The user wants to find installation guidance for the legacy Date and Time Picker ActiveX control in Excel for Microsoft 365.

- Product
- Microsoft Excel for Microsoft 365
- Device & OS
- not provided
- Scenario
- Adding a date picker to a worksheet when the control is missing from the Additional Controls list.
- Observed behavior
- The Microsoft Date and Time Picker control does not appear under Additional Controls.
In desktop Excel for Windows, select File > Account > About Excel to check whether your installation is 32-bit or 64-bit. The legacy Date and Time Picker control is not compatible with 64-bit Excel.
Use a Calendar Add-in Instead of the Legacy ActiveX Control
Use an add-in when you need a calendar interface and the legacy control is unavailable or incompatible.
In Excel, select Insert > Get Add-ins. The button may be labeled Office Add-ins in some versions.
Search the store for date picker or calendar, then review an add-in's compatibility, permissions, and instructions.
Select Add for a suitable add-in, then follow its instructions to enter dates into worksheet cells.

Check Guidance for the Legacy Date and Time Picker Control
Use this route if you specifically need the legacy control in 32-bit desktop Excel for Windows.
Restrict Worksheet Entries to Valid Dates
Use date validation when you only need to prevent invalid date entries, rather than display a calendar.
Work With Date-Based Spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open existing Excel files and continue editing your worksheets without installing the legacy Excel ActiveX control. WPS Office does not fix or replace that control in Microsoft Excel.

Frequently Asked Questions
Why is the Date and Time Picker missing from Additional Controls?
The legacy control may not be installed or registered, and it is not compatible with 64-bit Excel. Check your Excel version under File > Account > About Excel.
Can I install the legacy date picker in 64-bit Excel 365?
No. The legacy Date and Time Picker ActiveX control is not compatible with 64-bit Excel. Consider a calendar add-in or a custom VBA form instead.
How do I find a calendar add-in in Excel?
Select Insert > Get Add-ins and search for date picker or calendar. Check the add-in's compatibility and instructions before selecting Add.
Does Excel date validation display a calendar?
No. Data > Data Validation can restrict entries to a date range, but it does not provide a calendar popup.
Where is the Developer tab in Excel?
In desktop Excel for Windows, select File > Options > Customize Ribbon, check Developer, and select OK.




