To insert a date picker in Excel, enable the Developer tab (File, Options, Customize Ribbon), choose Insert, More Controls, and add Microsoft Date and Time Picker Control 6.0, or install a calendar add-in from Home, Add-ins. The legacy ActiveX picker is 32-bit only and does not load in 64-bit Office, and ActiveX is disabled by default in Microsoft 365 and Office 2024 (both points rest on Microsoft Q&A answers). Practice with the free Excel practice test on PracticeTestGeeks (500+ questions with answer explanations).
Excel has no built-in calendar button, so many workbooks use Data Validation instead (Data, Data Validation, Allow: Date) to reject invalid dates. This guide shows each way to add a date picker in Excel, with exact menu paths, a linking step, and fixes for the most common failures. Every date is stored as a serial number, so the picker only changes what you see, not the underlying value.
Excel stores every date as a serial number (January 1, 1900 is 1), so a picker writes a number and the cell format decides how it looks. Mismatched regional formats such as 03/04/2026 read as March 4 or April 3, which is why controlling entry matters.
The methods below build on each other. Data Validation is the baseline that works on Windows, Mac and the web, the ActiveX control is the classic 32-bit Windows answer, an add-in from Home, Add-ins is the modern route, and a VBA UserForm is the custom option.
You can continue preparing with the ms excel download free, which includes answer explanations for every question.
You can continue preparing with the excel latest version, which includes answer explanations for every question.
Readers who want more detail usually continue with insert date picker in excel.
Facts verified Oct 17, 2026 against Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business. Dates that have passed are removed automatically.
Facts verified Oct 17, 2026 against Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business. Dates that have passed are removed automatically.
| Item | Detail | Official source |
|---|---|---|
| Number of questions (Excel Associate (MO-210)) | 33-37 questions | certiport.pearsonvue.com |
| Number of questions (Excel Expert (MO-211)) | 23-27 questions | certiport.pearsonvue.com |
| Time limit | 50 minutes (60 minutes seat time) | Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business |
| Passing score | 700 on a 1β1000 scale | certiport.pearsonvue.com |
| Retake policy | Wait 24h after 1st fail, 48h before each later retake; no annual limit | Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business |
| Validity | Valid 5 years (earned on/after Sept 23, 2025) | certiport.pearsonvue.com |
| Delivery | Proctored live-in-the-application exam via Certiport Authorized Testing Centers (in-center or remote-proctored) | Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business |
| Eligibility | No formal prerequisites; about 150 hours of instruction and hands-on experience recommended | Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business |
| Score release | Score report at end of exam; also in Certiport profile | certiport.pearsonvue.com |
Facts verified Oct 17, 2026 against Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business. Dates that have passed are removed automatically.
Interactive Excel resources on PracticeTestGeeks, free to start:
Reference of the verified ways to insert a date picker or date control, with where each one starts:
| Method | Where to start | Steps in short | Needs |
|---|---|---|---|
| Data Validation, Allow: Date | Data > Data Validation | Select cells, set Allow to Date, choose a rule such as between, enter start and end dates | No macros; Windows, Mac, web |
| Data Validation, Allow: List | Data > Data Validation | Set Allow to List, point Source at a range of dates, keep In-cell dropdown checked | No macros; Windows, Mac, web |
| Microsoft Date and Time Picker Control 6.0 | Developer > Insert > More Controls | Draw the control, open Properties, set LinkedCell, turn off Design Mode | 32-bit Windows Office; ActiveX enabled |
| Office Add-in date picker | Home > Add-ins | Open More Add-ins, search for a date picker, select Add | Windows and Mac documented; some add-ins are paid |
| VBA UserForm calendar | Developer > Visual Basic | Alt+F11, Insert UserForm, add day buttons, call the form from a sheet event | .xlsm file; cannot open in Excel for the web |
Sources: Apply data validation to cells, ActiveX controls are disabled by default in Microsoft 365 and Office 2024, Add or remove add-ins in Excel, Workbooks with features unsupported by Excel for the web.
Use Data, Data Validation, Allow: Date to restrict entries to a range, or Allow: List with a helper range of dates for a drop-down. Microsoft documents both for Windows, Mac and the web.
The classic Microsoft Date and Time Picker Control 6.0 from Developer, Insert, More Controls. It is 32-bit only and does not load in 64-bit Office, and ActiveX is disabled by default in Microsoft 365 and Office 2024 (Microsoft Q&A answers).
Find calendar add-ins under Home, Add-ins. Microsoft documents the store on Windows and Mac; features, price and platform support are set by each publisher, so read the listing.
Build a calendar form from buttons and open it from a worksheet event. Full control over the look, but it needs a macro-enabled .xlsm workbook, which Excel for the web cannot open.
Data Validation is the simplest way to control dates and works the same way across Windows, Mac and the web. Select the cells, go to Data, Data Validation, set Allow to Date, choose a rule such as between, and enter the start and end dates or a formula like =TODAY(). Excel then rejects anything outside your range.
For a drop-down, type a list of dates on a helper sheet, name the range (for example DatePickerList), then set Allow to List and enter =DatePickerList as the Source. Keep In-cell dropdown checked so the arrow appears. Anyone opening the workbook can use it without macros, add-ins or security prompts.
Add conditional formatting to guide users. A formula such as =WEEKDAY(A1,2)>5 shades weekend dates, and =A1<TODAY() flags dates in the past. Because these are rules, not controls, they keep working wherever the workbook is opened.
Prepare for the Microsoft Excel exam with our free practice test modules. Each quiz covers key topics to help you pass on your first try.
Enable the Developer tab through File, Options, Customize Ribbon, then click Insert, More Controls and choose Microsoft Date and Time Picker Control 6.0. Draw it on the sheet, turn off Design Mode, and set LinkedCell in Properties so the picked date lands in a cell.
Limits: according to Microsoft Q&A answers the control is 32-bit only and does not load in 64-bit Office, and ActiveX is disabled by default in Microsoft 365 and Office 2024. Use it only when you control every userβs Office setup.
On the Home tab choose Add-ins, then More Add-ins on Windows, and search for a date picker. Select Add and follow the prompts. Microsoft documents this for Windows and Mac, and notes some add-ins must be purchased.
Features, pricing and platform support are set by each publisher, so check the listing. An add-in avoids ActiveX and macros, which makes it easier for IT teams to review than a macro-enabled workbook.
Open the editor with Alt+F11, insert a UserForm, and build a month grid from CommandButtons. Call the form from Worksheet_BeforeDoubleClick, and write the chosen date back to the clicked cell.
You control the appearance and can restrict selectable dates. The trade-off is that recipients must enable macros and the file must be .xlsm, and workbooks with VBA projects cannot be opened in Excel for the web.
When the file will be opened on Windows, Mac and Excel for the web, skip ActiveX and VBA. Use Data Validation (Allow: Date or Allow: List) as the baseline that every platform can use, and treat an add-in as an optional extra for users who install it.
A VBA UserForm calendar is the most flexible option. Press Alt+F11, choose Insert, UserForm, and add a label for the month and year, navigation buttons, and a grid of CommandButtons for the days. Name them systematically, for example btnDay01 to btnDay42.
On open, the code uses DATE and WEEKDAY to find the weekday of the first day of the month, then assigns day numbers to the buttons and hides the rest. Previous and next buttons change the month.
To wire the form to a sheet, add a Worksheet_BeforeDoubleClick event in the sheet module. If the double-clicked cell is in your date range, cancel the default edit and show the form. The day buttonβs Click event writes the date into that cell and unloads the form.
Keyboard support is worth adding with the UserForm_KeyDown event, so users can move with arrow keys and confirm with Enter. For distribution, save as .xlsm and expect recipients to click Enable Content, or package the code as an .xlam add-in or sign the project. Workbooks with VBA projects cannot be opened in Excel for the web.
Missing from More Controls: this almost always means 64-bit Office. Confirm the bitness under File, Account, About Excel. The control does not load in 64-bit Office (Microsoft Q&A answers), so use an add-in from Home, Add-ins, a UserForm, or Data Validation.
Control inactive or cannot be inserted: ActiveX is disabled by default in Microsoft 365 and Office 2024. You can change it under File, Options, Trust Center, Trust Center Settings, ActiveX Settings, but Microsoft strongly encourages leaving it disabled unless necessary.
A serial number instead of a date: the linked cell needs a date format. Right-click it, choose Format Cells, select Date, and pick a format. The value is a serial number, so formulas work regardless of the display format.
Day and month swapped: store the serial number and apply the display format separately, because regional settings decide how typed text such as 03/04/2026 is read. Data Validation with Allow: Date also rejects text entries.
Picker does not respond: turn off Design Mode on the Developer tab. If macros are blocked, the file may show a security warning until the user clicks Enable Content.
Many controls slow the sheet: use one shared picker or a UserForm opened by an event instead of one control per row.
To choose a method, start from the platform. For a small team on 32-bit Windows Office with ActiveX enabled, the Date and Time Picker is quick to insert. For mixed environments, Data Validation is the dependable baseline because Microsoft documents it for Windows, Mac and the web.
If you want a calendar pane, look under Home, Add-ins and read each listing for platform and pricing. If you need full control, build a VBA UserForm and accept the .xlsm requirement.
Always test on a clean machine before distributing, with attention to macro warnings, bitness and cell formats. Pair the picker with conditional formatting and protected cells so entries stay consistent.