Aug 13, 20232 min read

How To Insert Userform In Excel 2016 For Mac

Let's say, you've written a formula to count the number of orders between the specified dates. To prevent your users from inputting incorrect dates like 2/30/2016, you inserted the dropdown calendars in 2 cells (A2 and B2 in this example). However, your obviously correct COUNTIFS formula returns zero, although you can clearly see a few orders within the specified time period!The reason is that Excel cannot recognize the value of a date picker control until you associate it with a certain cell. To fix this, link your date picker controls to some cells in this way:

Note. Although you can register the calendar control for Windows 64 bit, it will work for Office 32 bit only. Even if you add a reference to mscomct2.ocx/mscal.ocx in Excel 64 bit, it will still return the "Could not load an object because it is not available on this machine" error.Third-party tools to insert calendar in ExcelAs already mentioned, Microsoft's Date and Time Picker controls work only in the 32-bit versions of Excel. If moving from 64-bits to 32-bits is not your option, third party tools are the only working solution. Below you will find a few calendars that work with both 32 bit and 64 bit versions of Excel 2019, Excel 2016, Excel 2013, and lower. It would be only natural if we start with our own calendar :)