Skip to content
Home » Install In-Cell Date Picker Calendar in Excel – Calendar Drop-down in Column

Install In-Cell Date Picker Calendar in Excel – Calendar Drop-down in Column

     

    In the tutorial I am going to show you how to include a date-picker in your Excel worksheet.  The tutorial includes two ways of achieving this.

    Click here to download the featured file.

    The first method uses Sam Radakovitz’s Date Picker add-in which is compatible with all versions of Excel. Sam is a Microsoft employee and lead on Excel. The second method uses the Mini Calendar and Date Picker by Vertex 42 which is found in the Microsoft store. Both add-ins are free to use.

    METHOD 1: Sam Radakovitz’s Date Picker Add-In

    This part of the video tutorial starts here: https://youtu.be/i3YDAuUVoes?t=74

    To use Sam’s add-in you need to:

    1. Head over to his website page http://samradapps.com/datepicker
    2. Scroll down the webpage until you see the link to download the date-picker add-in.  This will download a zip folder
    3. Open the zip folder and copy the Excel add-in
    4. 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
    5. Paste the add-in into this folder
    6. In File Explorer copy the path of the folder you have just created
    7. In Excel, select the ribbon’s File tab and then select Options (bottom left)
    8. In the Excel Options dialog select Advanced
    9. Under General (scroll almost to the bottom to see this), paste the folder’s path into the box labelled At Startup, open files in:
    10. Click on OK to confirm
    11. Close down Excel and re-open
    12. Create a blank workbook or open an existing file and you should see a Date Picker button appear on the ribbon

    If the Date Picker button disappears when you next use Excel, you need to change the permissions for the add-in.  To change the permissions, follow these steps:

    This part of the video tutorial starts here: https://youtu.be/i3YDAuUVoes?t=182

    1. In File Explorer navigate to the folder you created
    2. Right-click on the add-in and select Properties in the menu
    3. On the General tab in the Security section, tick Unblock
    4. Click on OK to confirm
    5. Close and reopen Excel and you should find the Date Picker button has reappeared on Excel’s ribbon

    How Does Sam’s Date Picker Work?

    This part of the video tutorial starts here: https://youtu.be/i3YDAuUVoes?t=216

    To use the date picker to enter dates in a cell or column:

    1. Click in a cell where you want to enter a date
    2. Click on the Date Picker button and select a date
    3. Once the date picker has been used in one cell, the rest of the cells in that column will display a Date Picker button when selected
    4. You can also right-click in a cell and select Date Picker at the top of the menu
    5. You also insert the date and time from the Date Picker button

    Method 2: Mini Calendar and Date Picker by Vertex 42 Add-in

    This part of the video tutorial starts here: https://youtu.be/i3YDAuUVoes?t=328

    To use the Mini Calendar and Date Picker by Vertex 42, follow these steps:

    1. Display the Developer tab on Excel’s ribbon by right-clicking on an existing tab and selecting Customise the Ribbon.
    2. In the Excel Options dialog tick Developer (bottom-right)
    3. Click OK to confirm
    4. On the Developer tab, click the Add-ins button
    5. In the Office Add-ins screen, select STORE
    6. In the Search box type datepicker
    7. Next to Mini Calendar and Date Picker click on the Add button
    8. Click Continue

    There a various customisation options for this add-in which I discuss at this point in the video https://youtu.be/i3YDAuUVoes?t=363

    This next of the video tutorial starts here: https://youtu.be/i3YDAuUVoes?t=392

    This date-picker is a floating object and so might get in the way.  I decided to place the data picker in an empty row above my data.  You can obviously resize the row and data picker so it fits.  You can then freeze that row so the date picker is always visible.  To freeze rows:

    1. Click in the left-most cell of the row beneath the row or rows you want to freeze
    2. Select the View tab on Excel’s ribbon
    3. Click Freeze Panes | Freeze Panes

    How Does the Mini Calendar and Date Picker by Vertex 42 Add-in Work?

    This part of the video tutorial starts here: https://youtu.be/i3YDAuUVoes?t=415

    To use the Mini Calendar and Date Picker by Vertex 42 Add-in, follow these steps:

    1. Click in the cell where you want the date or time to appear
    2. Select a date from the date picker or click on the time button to enter the current time

    This add-in allows you to add date and time separately which Sam’s add-in does not allow you to do.

    The next part of the video tutorial starts here: https://youtu.be/i3YDAuUVoes?t=477

    To use the date picker on another worksheet, follow these steps:

    1. Select the worksheet
    2. On the Developer tab, click the Add-ins button
    3. In the Office Add-ins screen select the Mini Calendar and Date Picker add-in
    4. Click on Add (bottom-right)
    5. The date picker will appear in the worksheet

    Vertex42 had created some useful Excel templates and add-ins – click here to see their offerings.

    Shortcut Keys for Entering the Current Date and Time

    These shortcut keys will work with or without these date-picker add-ins installed.

    CTRL ;  (current date)

    CTRL SHIFT ; (current time)