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.
How to Add and Use a Date Picker in Excel 64-Bit: With Alternatives
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.
- Following, you will get to see a window, where Excel wants to make sure that you agree to the provider’s license terms and privacy policy.
- 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 Use Excel UserForm as Date Picker
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.
🔀 Steps:
- 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.
Download Practice Workbook
Here is a practice workbook for you. Download it and use it while reading this article.
Conclusion
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. Happy Excelling!
Related Articles
- [Solved!] Datepicker Not Showing in Excel
- Excel Date Picker for Entire Column
- How to Insert Calendar in Excel Cell
<< Go Back to Excel Date Picker | Learn Excel
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
Regards
ExcelDemy