Skip to main content ExcelDatePicker.com to main content

Pick Date in Excel
using Excel Date Picker

Excel Date Picker adds a pop-up calendar to Microsoft Excel 2003, 2007, 2010, 2013 and 2016. No more confusion in Excel date format.

Download Now

 Share This Page

Get a pop-up calendar whenever you need it!

Since 2006 Excel Date Picker / Pop-up Excel Calendar has been served in over 150 countries.
Getting confused about working with dates in Excel? Is it dd/mm/yy or mm/dd/yyyy? Should you use slashes or dashes or dots? Download Excel Date Picker now to eliminate all these Headache.


Smart Date Picker

Pops up the calendar whenever needed - for cells that have date values, date formats, underneath date values, formats or certain labels.

Learn More

Supple Date Picker

Applies user-defined date format to target cells if needed; Shows or hides week numbers, or even shows several months on the calendar.

Learn More

Simple Date Picker

Once installed, it works for any Excel workbooks on this computer. No macros, no security concerns, no modifications to your Excels files.

Learn More

Excel Date Picker

Excel Date Picker

Smart Date Picker for Excel

1/2/2014, 2/1/2014, 1-2-2014, 2-1-2014, 1.2.2014, 2.1.2014 ... These could all be valid date values in Excel, and depending on your Excel and Windows settings, they could mean February 1 2014 or January 2 2014. So at the time you need to enter a date value, which one do you choose? Or when you receive or download an Excel file, which day a date value is actually referring to?

Excel Date Picker solves all the headaches by showing you a calendar whenever you click or move to a date cell, making dates in Excel easy to work with.

Need to enter a date value into a cell? Click your mouse on the cell in which you must enter a date. An in-cell icon button appears. Click the icon button to display the calendar. Click the date you want to enter and you are done!

If you like, you can even have the datepicker display automatically as soon as a date-formatted cell is selected.

By default, the in-cell icon button is displayed automatically when you click a cell which is:

  • Formatted as date. To set the format of a cell in Excel, right click the cell and choose Format Cells. On the Number tab choose Date in the Category list, and then choose a proper date format in the Type list.
  • Filled with a date-like value. For example, if a cell is formatted as "General" but has a date-like value "September 1 2006", Pop-up Excel Calendar will display the in-cell icon button when you click the cell.
  • Underneath a cell with a date value or format in it. For example, if a cell has a "General" format and its value is empty, Pop-up Excel Calendar still can display the in-cell icon button if the cell on the top of it has a date value or format.
  • Underneath a cell that has some form of the word "date" in it.

You can enable or disable the above options respectively in the Settings window, which can be opened by clicking the Settings button on the Pop-up Excel Calendar toolbar, or clicking the Settings button on the pop-up calendar window.

Supple Date Picker for Excel

Excel Date Picker / Pop-up Excel Calendar offers a number of options to let you controls how it works.

  •  First day of week.
  •  The start year and end year appear on the year-selection box.
  •  Apply (or not) a default date format if the target cell does not have one.
  •  Whether to display the calendar automatically.
  •  Whether to work with a date contains time.
  •  Show or hide week numbers.
  •  How many months to show, both in width and height, on the calendar.
  •  Background color, border color, font color.
  •  Custom date formats that should be seen as valid or invalid date formats.
  •  A default date value shown on the calendar.
  •  Show or hide the command on the right-click shortcut menu.

If the target cell is not formatted as date, you can choose to have Pop-up Excel Calendar set a date format automatically. This option can be enabled or disabled in the Settings window, which can be opened by clicking the Settings button on the Pop-up Excel Calendar toolbar, or clicking the Settings button on the pop-up calendar window.

To specify the default date format, enter a format string in the box underneath the Apply the following date format if the target cell is not formatted as date checkbox.

A date format string is constructed with format codes, which describe how you want to display date. For example, if your default date format is "mm/dd/yyyy", "September 1, 2014" will be formatted as "09/01/2014". The following tables shows you all the valid codes that you can use in the date format string.

To display Use this code
Months as 1-12 m
Months as 01-12 mm
Months as Jan-Dec mmm
Months as January-December mmmm
Days as 1-31 d
Days as 01-31 dd
Years as 00-99 yy
Years as 1900-9999 yyyy

In addition to any valid combinations of the above format codes, you can also enter "dddd" and "ddd" as the date format string.

To display Use this code
Full day of week name. eg. "Monday", "Tuesday", "Wednesday"... dddd
3 letter day of week name abbreviation. eg. "Mon", "Tue", "Wed"... ddd

The option "Date can contain time" allows you to specify whether Pop-up Excel Calendar works for the dates or formats that contain time. If this option is checked, a date containing time part will be seen as a normal date, and the time part is ignored. This option is unchecked by default.

For example, if a cell value is "December 3, 2002 16:17:18" and the "Date can contain time" option is checked, when you click the cell the calendar appears. If you uncheck the option, the calendar won't appear when you click the cell.

Pop-up Excel Calendar

Pop-up Excel Calendar (Excel Date Picker)

Excel Date Picker Settings

Excel Date Picker (Pop-up Excel Calendar) Settings

Simple Date Picker for Excel

Excel Date Picker works with all major Microsoft Excel versions on Windows - Excel 2003, Excel 2007, Excel 2010 and Excel 2013, both 64-bit and 32-bit.

Implemented as a COM add-in program. No macro or VBA is required. Installed once on a computer and works with any workbook files on the computer.

In Excel 2007, Excel 2010 and Excel 2013, by default Pop-up Excel Calendar creates a separate tab "Pop-up Calendar" in the Ribbon-based user interface. The tab contains 5 buttons, as detailed below.

  • Calendar!

    Displays the pop-up calendar manually. Generally you don't need this button to display the pop-up calendar, as the in-cell icon button is shown automatically when you click a date cell.

  • Settings

    Displays the Settings window, in which you can control how the pop-up calendar works for you.

  • Disable

    Disables the pop-up calendar. If this button is pushed, the in-cell icon button won't be shown even if you click a cell that is formatted as date. Click the button again to enable the calendar.

  • Help

    Opens the help document.

  • About Pop-up Excel Calendar

    Copyright and license information. You will need this button to enter you registration code/license key to unlock the program.

If you prefer, you can also have the Pop-up Calendar ribbon group shown in the Insert tab.

In Excel 2003, Excel Date Picker / Pop-up Excel Calendar provides a toolbar, which consists of 5 buttons, corresponding to the 5 command buttons in Excel 2007, Excel 2010 and Excel 2013.

Want to learn more about our Excel Date Picker / Pop-up Excel Calendar? See some screenshots to get a quick idea or
Download and try it

Are you coming here by looking for a jQuery date picker? Our favorites are: Datepicker | jQuery UI, Datepicker for Bootstrap. For information on Microsoft's Date Picker class see Date Picker Class. Don't forget to visit our date picker at Pop-up Excel Calendar - Date Picker for Excel.