How to Use Date Picker in Excel 64-Bit (with an Alternative)

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.

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.

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

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.

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

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. Also, visit our blog, to learn more about Excel. Happy Excelling!

Related Articles

• [Solved!] Datepicker Not Showing in Excel
• Excel Date Picker for Entire Column