As per the authorized statement from the moderators of answers.microsoft.com, MS Excel’s Date Picker feature is available only in 32-bit versions of Excel 2016, Excel 2013, and Excel 2010, but the default Date Picker feature won’t work on Excel 64-bit. So, if you cannot but insert a Date Picker in 64-bit versions of Excel, the only way you have is- to use a third-party add-in. In this article, I will show you how to insert and use a third-party Date Picker in Excel 64-bit versions.
If you use 32-bit versions of Excel, check the following article to know how to insert a Date Picker in Excel 32-bit: How to Insert a Date Picker in Excel (With Step-by-Step Procedure)
Download Practice Workbook
Here is a practice workbook for you. Download it and use it while reading this article.
How to Add and Use a Date Picker in Excel 64-Bit
Follow the instructions below to add and use a third-party Date Picker Add-in in Excel 64-bit versions.
1. Adding a Suitable Date Picker Add-in from Microsoft Store
- Go to the Insert tab and click on the Get Add-ins command to navigate to the Office Add-ins popup.
- In the search box, type “date picker” and click on the 🔎 icon to search for related results.
- The Mini Calendar and Date Picker add-in will be at the top of the list if you sort the results by popularity. This add-in is developed by VERTEX42.COM.
Before starting to add and use it let us tell you two things.
- This add-in can read and make changes to your document.
- It can send data over the internet.
If you are okay with these, then proceed to the next steps.
- Now, press Add command.
- Check them out and if you are okay with that, then click on Continue.
- Consequently, you will get the Date Picker in the current worksheet. This will look like the following image.
Read More: Insert Drop Down Calendar in Excel Without Date Picker
2. Using the Date Picker
i. Adding Schedule Dates with Date Picker
Assuming that we will make a final exam routine for a school. Here is a sample of this. The Subjects are listed in the left column, and we will insert exam dates in the right column using Date Picker.
- To do that, click on a cell in the Date column first (we have selected Cell C5 in our case).
- Then using the right or left arrows in the Date Picker, find the correct year and month (January 2023 in our case).
- Then click on the date you want to schedule the exam.
- Similarly, add all the scheduled dates from this calendar. Your Routine will now look like the following image.
ii. Changing Position of the Date Picker
- When you click on the Date Picker, a border will be visible.
- Hover your mouse to the borderline and you will see a thick cross arrow ✥ appears. This is a dragging tool.
- Now, drag the Date-Picker to the desired position.
iii. Formatting the Date Picker
If you look down the Date Picker window, a list of command icons will be visible.
- The first icon is to toggle calendar size.
- The second icon is to change the calendar theme. There are 5 built-in themes here.
- The next command sets the calendar system.
- The 4th command creates a serial number for each of the weeks throughout the year in the calendar.
- To show or hide these commands, use the following icon.
iv. Deleting the Date Picker Window
- After inserting desired dates, if you want to delete the Date Picker now, just click on it and a left arrow will be visible in the top right corner.
- Click on it and then select Delete from the list of commands.
Deleting the Date Picker will not delete dates generated by it.
Read More: How to Create a Date Picker in Excel Using VBA (with Easy Steps)
An Alternative to Date Picker: Use a Calendar Template of Microsoft Excel
If you have a 64-bit version and don’t want to use any third-party add-ins for security concerns, then You can use a built-in calendar of MS Excel as an alternative.
- Open Excel and click on New.
- In the search box, type calendar and click the 🔎 icon.
- Now, select a suitable calendar format.
- Here we have selected the Any Year Calendar.
- Now, press the Create button.
- A calendar with months in separate worksheets will appear. Here, we have applied some formatting and hence the calendar looks like the image below.
- You can type the desired year in Cell K5 and select week start from the drop-down in Cell K6.
- You can add comments or work schedules in the cell right below the date cells, i.e. B6:H6, B8:H8, etc.
Here we are to conclude now. We hope, Excel will add this feature for 64-bit versions soon. But till then, we have to use a third-party date picker or use 32-bit versions of Excel. If you find any problem, regarding the topic, please let us know. Also, visit our blog, to learn more about Excel. Happy Excelling!
Why on earth wouldn’t Excel add such a useful feature to 64 bit versions of excel? So lame!
Hello, Joe Smith!
The 64-bit version of Excel is not compatible with 32-bit active x controls. To know more about it you can visit this site