To change the permissions, follow these steps: If the Date Picker button disappears when you next use Excel, you need to change the permissions for the add-in. Create a blank workbook or open an existing file and you should see a Date Picker button appear on the ribbon.

Under General (scroll almost to the bottom to see this), paste the folder’s path into the box labelled At Startup, open files in:.

In the Excel Options dialog select Advanced.

In Excel, select the ribbon’s File tab and then select Options (bottom left).

In File Explorer copy the path of the folder you have just created.

Sam’s website gives some suggestion as to how and where to install the add-in, alternatively you can create a folder in the root of your C: drive – name the folder something like Excel Startup Folder.

Open the zip folder and copy the Excel add-in.

Scroll down the webpage until you see the link to download the date-picker add-in.

This part of the video tutorial starts here: METHOD 1: Sam Radakovitz’s Date Picker Add-In The second method uses the Mini Calendar and Date Picker by Vertex 42 which is found in the Microsoft store. Sam is a Microsoft employee and lead on Excel.

The first method uses Sam Radakovitz’s Date Picker add-in which is compatible with all versions of Excel. The tutorial includes two ways of achieving this.Ĭlick here to download the featured file. In the tutorial I am going to show you how to include a date-picker in your Excel worksheet.

Excel date picker in cell