How to Insert a Date Picker in Excel: The Complete 2026 Guide to Calendar Controls, ActiveX Date Pickers, and Pop-Up Calendars
Learn how to insert date picker in Excel with ActiveX controls, calendar pop-ups, VBA UserForms, and add-ins. Complete 2026 step-by-step tutorial.

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.
Microsoft Excel: upcoming dates and official changes
- Jun 30, 2026: Certiport retired the Microsoft Office Specialist 2016 certifications, including MOS Excel 2016, on June 30, 2026. The Microsoft 365 Apps and Office 2019 Excel exams are still available. (certiport.pearsonvue.com)
- Updated Oct 16, 2026: Delivery is now Proctored live-in-the-application exam via Certiport Authorized Testing Centers (in-center or remote-proctored) (previously Proctored live-in-the-application exam via Certiport Authorized Testing Centers).
- Updated Oct 16, 2026: Eligibility is now No formal prerequisites; about 150 hours of instruction and hands-on experience recommended (previously No formal prerequisites; ~150 hours of instruction and hands-on experience recommended (Associate)).
- Updated Oct 16, 2026: Time limit is now 50 minutes (60 minutes seat time) (previously 50 minutes (60 minutes seat time)).
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.
- The MOS Excel (Microsoft 365 Apps) exam has 33 to 37 questions. (certiport.pearsonvue.com)
- The MOS Excel Expert (Microsoft 365 Apps) exam has 23 to 27 questions. (certiport.pearsonvue.com)
- Microsoft Office Specialist Excel exams last 50 minutes, with 60 minutes of total seat time. (Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business)
- The passing score for Microsoft Office Specialist Excel exams is always 700 on Certiport's 1 to 1000 scaled score. (certiport.pearsonvue.com)
- After failing a Microsoft Office Specialist Excel exam, candidates must wait 24 hours before the first retake and 48 hours before each later retake, and there is no annual limit on attempts. (Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business)
- Microsoft Office Specialist Excel certifications earned on or after September 23, 2025 are valid for five years; those earned earlier do not expire. (certiport.pearsonvue.com)
- The Microsoft Office Specialist Excel exam is proctored and delivered live in the Excel application through Certiport Authorized Testing Centers, either in person or remote-proctored. (Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business)
- Microsoft recommends that candidates for the MOS Excel Associate (Microsoft 365 Apps) certification have about 150 hours of instruction and hands-on experience with Excel. (Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business)
- Candidates get their MOS Excel score report as soon as they finish the exam, and it can also be viewed in their 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.
Microsoft Excel Exam at a Glance
| 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.
Free Excel Study Tools
Interactive Excel resources on PracticeTestGeeks, free to start:
- Free Excel Questions and Answers — 16 questions with instant scoring and answer explanations
- Excel flashcards — review key terms and concepts card by card
- Excel study guide — topic-by-topic overview of what the exam covers
- Excel cheat sheet — one-page printable summary for last-minute review
Date Picker in Excel by the Numbers
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 |

Four Ways to Insert a Date Picker in Excel
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.

Microsoft Excel Practice Test Questions
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.
Microsoft Excel Excel Basic and Advance
Microsoft Excel Exam Questions covering Excel Basic and Advance. Master Microsoft Excel Test concepts for certification prep.
Microsoft Excel Excel Formulas
Free Microsoft Excel Practice Test featuring Excel Formulas. Improve your Microsoft Excel Exam score with mock test prep.
Microsoft Excel Excel Functions
Microsoft Excel Mock Exam on Excel Functions. Microsoft Excel Study Guide questions to pass on your first try.
Microsoft Excel Excel MCQ
Microsoft Excel Test Prep for Excel MCQ. Practice Microsoft Excel Quiz questions and boost your score.
Microsoft Excel Excel
Microsoft Excel Questions and Answers on Excel. Free Microsoft Excel practice for exam readiness.
Microsoft Excel Excel Trivia
Microsoft Excel Mock Test covering Excel Trivia. Online Microsoft Excel Test practice with instant feedback.
ActiveX Date Picker vs Modern Alternatives
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.
ActiveX Picker or a Modern Alternative?
- +Data Validation needs no macros, controls or add-ins
- +Data Validation is documented for Windows, Mac and the web
- +Add-ins from Home, Add-ins avoid ActiveX and VBA
- +A UserForm gives full control over layout and allowed dates
- +Any method can write real date serial numbers that formulas can use
- −The ActiveX picker is 32-bit only per Microsoft Q&A answers
- −ActiveX is disabled by default in Microsoft 365 and Office 2024
- −Data Validation shows no calendar, only a rule or a list
- −Some add-ins must be purchased and vary by publisher
- −VBA workbooks cannot be opened in Excel for the web

How to Insert a Date Picker in Excel: Checklist
- ✓Check whether Office is 32-bit or 64-bit under File, Account, About Excel
- ✓Show the Developer tab through File, Options, Customize Ribbon
- ✓Pick a method: Data Validation, ActiveX, add-in, or VBA UserForm
- ✓For ActiveX, confirm it is enabled under File, Options, Trust Center, Trust Center Settings, ActiveX Settings
- ✓Click Insert, More Controls and choose Microsoft Date and Time Picker Control 6.0
- ✓Draw the control, open Properties, and set LinkedCell to your target cell
- ✓For add-ins, use Home, Add-ins, then More Add-ins on Windows and search for a date picker
- ✓Format the linked cell as a date so it does not show a serial number
- ✓Save as .xlsm if you use ActiveX or VBA so the code is preserved
- ✓Test on a colleague’s machine, including their bitness, before sharing
Use a hybrid approach for cross-platform workbooks
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.
According to Microsoft Q&A answers, the Microsoft Date and Time Picker control is 32-bit only and does not load in 64-bit Office. A file built on 32-bit Office may show a broken control on a 64-bit machine. If your audience includes 64-bit users, use Data Validation, an add-in or a VBA UserForm instead.
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.
Excel Questions and Answers
Written and edited by Nathan Beja, founder of Practice Test Geeks, with AI assistance. Exam facts are checked against the official sources linked below. Editorial policy
Sources & references
Exam facts on this page (fees, format, dates, passing scores) are checked against these official sources; the date is our last check. Editorial policy
- learn.microsoft.com — Retake policy, test delivery, time limit, eligibility · verified Oct 2026
- certiport.pearsonvue.com — Exam format, score validity, passing score, score release, exam information · verified Oct 2026




