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.

Microsoft ExcelOct 22, 202613 min readFacts verified Oct 17, 2026 against Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business
How to Insert a Date Picker in Excel: The Complete 2026 Guide to Calendar Controls, ActiveX Date Pickers, and Pop-Up Calendars

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.

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

ItemDetailOfficial source
Number of questions (Excel Associate (MO-210))33-37 questionscertiport.pearsonvue.com
Number of questions (Excel Expert (MO-211))23-27 questionscertiport.pearsonvue.com
Time limit50 minutes (60 minutes seat time)Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business
Passing score700 on a 1–1000 scalecertiport.pearsonvue.com
Retake policyWait 24h after 1st fail, 48h before each later retake; no annual limitMicrosoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business
ValidityValid 5 years (earned on/after Sept 23, 2025)certiport.pearsonvue.com
DeliveryProctored 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
EligibilityNo formal prerequisites; about 150 hours of instruction and hands-on experience recommendedMicrosoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business
Score releaseScore report at end of exam; also in Certiport profilecertiport.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:

Date Picker in Excel by the Numbers

💻32-bit onlyLegacy ActiveX picker bitnessMicrosoft Q&A answers
🛡️DisabledActiveX default settingMicrosoft 365 and Office 2024
🗓️Allow: DateData Validation pathData > Data Validation
🧩Home > Add-insAdd-in menu pathWindows and Mac

Reference of the verified ways to insert a date picker or date control, with where each one starts:

MethodWhere to startSteps in shortNeeds
Data Validation, Allow: DateData > Data ValidationSelect cells, set Allow to Date, choose a rule such as between, enter start and end datesNo macros; Windows, Mac, web
Data Validation, Allow: ListData > Data ValidationSet Allow to List, point Source at a range of dates, keep In-cell dropdown checkedNo macros; Windows, Mac, web
Microsoft Date and Time Picker Control 6.0Developer > Insert > More ControlsDraw the control, open Properties, set LinkedCell, turn off Design Mode32-bit Windows Office; ActiveX enabled
Office Add-in date pickerHome > Add-insOpen More Add-ins, search for a date picker, select AddWindows and Mac documented; some add-ins are paid
VBA UserForm calendarDeveloper > Visual BasicAlt+F11, Insert UserForm, add day buttons, call the form from a sheet event.xlsm file; cannot open in Excel for the web
Insert Date Picker in Excel - Microsoft Excel certification study resource

Four Ways to Insert a Date Picker in Excel

✅Data Validation Rule or List

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.

🛠️ActiveX Date Picker

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).

📦Office Add-in

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.

💻VBA UserForm

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 - Microsoft Excel certification study resource

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.

Microsoft Excel Basic and Advance Question...

Microsoft Excel Study Material on Basic and Advance Questions and Answers. Prepare effectively with real exam-style questions.

Microsoft Excel MCQ Questions and Answers

Microsoft Excel Study Material on MCQ Questions and Answers. Prepare effectively with real exam-style questions.

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?

✅Pros
  • +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
❌Cons
  • −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
Excel Spreadsheet - Microsoft Excel certification study resource

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.

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 , 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

  1. learn.microsoft.com — Retake policy, test delivery, time limit, eligibility · verified Oct 2026
  2. certiport.pearsonvue.com — Exam format, score validity, passing score, score release, exam information · verified Oct 2026