Excel Date Picker Tool

If you’d like a quick and easy way to add dates in a worksheet, you can use this handy date picker tool, from Jim Cone. It opens to the current date, and you can scroll through months and years, by using the scrollbars at the top of the date picker form.

datepicker01

Just select a cell, and click the insert button, to add the date. If you hold the Shift key, and click the Insert button, it will append the date to the cell’s contents.

datepicker11

Create Calendars on a Worksheet

In addition to inserting the date, Jim’s date picker will also add a calendar to the worksheet – either a single month, or a full year.

datepicker07

Download the Date Picker File

To see all the details, and to download the date picker file, please visit my Contextures website: Excel Date Picker

The file is in Excel 2003 format, and contains macros, so enable macros if you want to test the file. The VBA code is unlocked, so you’ll be able to poke around in the code, and see how it works.

Jim hasn’t tested the file in Excel 2013, but a quick test in that version worked fine for me.

__________________

8 comments to Excel Date Picker Tool

  • AMAL RAFIQ

    Thank u v v much for this knew information

  • Tony Poy

    how do you edit the excel date picker tool for 64 bit?

  • Date Pickers in Excel! Sounds Great.
    Can I use this in Excel 2013.

  • Jim Cone

    @Ankit Mac
    It worked for Debra in XL 2013.

    The program can be used in any workbook using he following steps:

    1. Open the downloaded workbook: "Get Your Own Date"
    2. Open your file.
    3. In the Visual Basic Editor (Alt +F11) and
    in the window at the top left... "Drag ArrDateForm" and "ModuleStuff" to your workbook.
    Copies are automatically created.
    4. Close the GetYourOwnDate workbook (without saving it).
    5. Double-click "ModuleStuff" and then in the top right window (near the top) place an apostrophe in front of the "Option Private Module " line.
    It will look like this: 'Option Private Module
    6. Add a button to the Quick Access Toolbar to run the "AskFor_A_Date" sub.
    Instructions can be found in Excel help under "Run a macro by clicking a button on the Quick Access Toolbar"

    The date picker should appear anytime you click the new QAT button.
    Save your workbook.

  • Hi all

    FYI

    Here is another Date Picker that work with Local formats and have Week Numbers also.
    Also you can start the week on a Monday (In Europe this is common)

    http://www.rondebruin.nl/win/addins/datepicker.htm

  • Jim Cone

    Hi Ron,
    For what it is worth...
    The Excel date picker tool, available at this site , automatically provides the correct weekday start in the local language.
    No manual adjustment is necessary.

    Hans Vogelaar was of great help in getting that part squared away.
    '---
    Jim Cone

  • Hi Jim

    Thanks for the Info, I add a link to your Date Picker on this page
    http://www.rondebruin.nl/win/s8/win003.htm

    Have a great day

  • I am new to excel. I have been looking for something like this in my excel spreadsheet. But I have one questions. I have a macro that when a date is entered in the "Date_Completed" column it removes the entire row and moves it to another worksheet in the same workbook. Can a date picer be used with this type of macro?

Leave a Reply

  

  

  

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>