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

Get FREE Advanced Excel Exercises with Solutions!

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.

inserting new add-in

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

search for date picker add-in in microsoft store

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

Excel Date Picker for 64 bit

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.

Adding Schedule Dates with Date Picker

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

Changing Position of the Date Picker

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

toggle calendar size

  • The second icon is to change the calendar theme.  There are 5 built-in themes here.

change the calendar theme

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

Note

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.

An Alternative to Date Picker: Use Calendar Template of Microsoft Excel

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

An Alternative to Date Picker: Use Calendar Template of Microsoft Excel


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


<< Go Back to Excel Date Picker | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Masum Mahdy
Masum Mahdy

Abu Talha Masum Mahdy (Assistant Project Manager, ExcelDemy) has been working with the ExcelDemy family for over 2 years. He wrote 30+ articles and reviewed more than 1300 others for ExcelDemy. Currently, he is responsible for reviewing articles from 2 writing teams of ExcelDemy. He ensures correctness and fluency in his team write-ups. Mahdy holds a BSc in Naval Architecture and Marine Engineering from BUET. His interests are Project Management, Content Writing, SEO, Digital Marketing, Data Analytics and... Read Full Bio

2 Comments
  1. 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

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo