Insert dates in cells from a handy date picker with easy date formatting

Every time you start entering a date in a cell, you wonder… Should you type MM/DD/YYYY or use some other order? Should you use ‘/’ or maybe ‘-’ separator? Will the date format display exactly as you want? That's when an Excel date picker, or a drop down calendar, comes in handy. Indispensable even, when you manage personal or business to-do lists, appointments or timetables, project trackers or financial reports in Excel spreadsheets.

The Popup Calendar is a comprehensive and reliable date picker trusted by 30 000+ Excel users:

  • Intuitive in use: click on a cell – pick a date
  • Drops down near a cell, displays week numbers, days of the week and the current date
  • Populates columns, rows or any ranges with date values in one click
  • Numerous default date format options, preset and custom
  • Works both in 64 bit and 32 bit Excel
(Note: the video may not reflect the latest upgrades. Please use the guide below.)

How to insert or change a date in a cell using the Popup Calendar

  1. Select a cell.
  2. In the Date/Time group, click theInsert Datebutton The date picker will drop down next to the cell.
    Or:right-click and chooseInsert Date.
    Or:use a shortcut – pressCtrl + ;(semi-colon).
  3. Pick a date you need from the calendar Done.
    Note:is it what you wanted? Learn how tochange the default date format.
  4. To change a date value, click on the Calendar icon to the right of the cell Change date.

The Popup Calendar remembers the last used date, so it is easier to insert a date the next time.

Note:after you enter a date, the cell is automatically assigned Number/Date format. If you delete the date value later, the cell will still keep its Date format, and the Popup Calendar icon will remain available for this blank cell. To remove the icon, change the cell's format to General.
Insert a date into a cell from the Popup Calendar

How to insert the current date in a cell from the date picker

  1. Select a cell where you want to insert the current date.
  2. In the Date/Time group, click theInsert Timebutton The Calendar will drop down.
    Or:right-click and chooseInsert date.
    Or:use a shortcut – pressCtrl + ;(semi-colon).
  3. ClickTodayon the bottom of the Calendar Done.

How to populate an entire column, row or non-adjacent cells range with dates

You can use the Popup Calendar to fill in dates throughout an entire range (limitation up to 4000 cells). Populate table columns, rows, merged cells, non-adjacent cells or any custom range just the same, as a single cell:

  1. Select a range.
  2. In the Date/Time group, click theInsert Timebutton The Calendar will drop down.
    Or:right-click and chooseInsert Date.
    Or:use a shortcut – pressCtrl + ;(semi-colon).
  3. Select a date Done. The whole range is populated with the selected date value.
  4. To change a date in a specific cell, click on the Calendar icon to the right of the cell Change the date.
Note:after you enter a date, the cells are automatically assigned Number/Date format. If you delete the date values later, the cells will still keep their Date format, and the Popup Calendar icon will remain available for these blank cells. To remove the icon, change the cells' format to General.
Populate a range with dates from the Popup Calendar

How to populate a range with consecutive dates

With the Popup Calendar you can quickly populate a range with consecutive dates (sequential days):

  1. XLTools tab Settings button Date/Time tab Check the boxAuto-increment dates when I use date picker for a range of cells OK.
  2. Select a range.
  3. In the Date/Time group, click theInsert Datebutton The date picker will appear.
    Or:right-click and chooseInsert Date.
    Or:use a shortcut – pressCtrl + ;(semi-colon).
  4. Pick the starting date to fill the range Done, the whole range is automatically filled with consecutive date values with 1 day increments.
Insert consecutive dates from the Popup Calendar

How to insert both date and time into a cell

  1. Select a cell.
  2. In the Date/Time group, click theDate & Timebutton The Popup Calendar with Clock will appear next to the cell.
    Or:right-click andInsert Date & Time.
    Or:use a shortcut – pressCtrl + ;(semi-colon), then release the keys and pressCtrl + Shift + ;(semi-colon).
  3. Set the time by using a scroll wheel or the Up/Down arrows Choose a date from the Popup Calendar Done.
    Note:the time format: is it what you wanted? You can change thedefault format of the Popup Calendar and Clock.
  4. To change an entry, click on the icon to the right of the cell Change time and date.
Note:after you enter date and time, the cell is automatically assigned Number/Date format. If you delete the value later, the cell will still keep its Date format, and the Popup Calendar with Clock icon will remain available for this blank cell. To remove the icon, change the cell's format to General.
Insert both date and time into a cell from the date picker

How to insert only time (without date) into a cell

Use thePopup Clocktime picker to set and insert time into cells and ranges:

  1. Select a cell or a range.
  2. In the Date/Time group, click theInsert Timebutton The Popup Clock will appear next to the cell.
    Or:right-click andInsert Time.
    Or:use a shortcut – pressCtrl + Shift + ;(semi-colon).
  3. Set the time by using a scroll wheel or the Up/Down arrows Press Enter Done.
Insert time only into a cell from the Popup Clock

How to change the default date format of the Popup Calendar

You can change the default date format of the Popup Calendar:

  1. ClickSettingson XLTools ribbon Date/Time tab.
  2. Check the boxUse the Date and Time format below as default.
    Note:if you uncheck this box, the Popup Calendar will use the format specified in your system settings.
  3. Select your preferred format, e.g. the format customary in your country or language.
    Or:define and set your custom format.
  4. Click OK Done.
Set custom date format for the Popup Calendar

You may find that some cells would not comply with the Calendar's format settings. It means the cells had been assigned a different date format earlier. In this case, change the cells' format:

  1. Select cells Right-click and chooseFormat cells.
  2. Open Number tab Date format Select the required date format.

Initially, the Popup Calendar employs your system settings for default date and time format. You can change your system settings altogether. note, this will affect all user accounts on your computer:

  1. Control Panel Clock, Language, and Region Region.
  2. Formats tab Set date and time formats, first day of the week.
  3. Location tab Set your home country location.
  4. Administrative tab Change system locale Restart your computer.

How to change a shortcut for the Popup Calendar

For your convenience, the default shortcut for the Popup Calendar isCtrl + ;(semi-colon) – the same combination used in Excel to insert the current date. You can change the Popup Calendar shortcut at any time:

XLTools tab Settings button Shortcuts tab Set a different shortcut OK.

Set shortcut keys for the Popup Calendar in Excel

How to add/remove the Popup Calendar icon

The Calendar icon appears to the right of a selected Excel cell, when the cell has Date format. Clicking the icon opens the date picker.

  • To disable the Calendar icon:

    1. ClickSettingson XLTools ribbon Date/Time tab.
    2. Uncheck the boxDisplay the Popup Calendar and Clock icons OK.
    3. Done! The icons will not display, but the Calendar and Clock will still be availalbe for use. You can bring the icons back at any time.
Hide or display Calendar drop-down icons in Excel
  • To make the Calendar icon readily available near a blank cell, column, row or custom range:

    1. Select a blank cell or a range.
    2. Home tab Number group Date OK. This will assign time format to the cells.
      Or:use the Popup Calendar to insert any date Press Delete. This will remove the actual date values and yet assign date format to the selected cells.
    3. Done! Now if you select any cell in this range, the Calendar icon will appear near that cell.
  • To remove the Calendar icon from empty cells:

    If a cell is empty, but it still has an icon beside it, it means that the cell still has date or time format assigned. To remove the icon from blank cells, change their format back to General:

    1. Select a blank cell or a range.
    2. Home tab Number group Date OK. This will assign time format to the cells.
      Or:use the Popup Calendar to insert any date Press Delete. This will remove the actual date values and yet assign date format to the selected cells.
    3. Done! Now if you select any cell in this range, the Calendar icon will appear near that cell.
  1. ClickSettingson XLTools ribbon Date/Time tab.
  2. Check/uncheck the relevant boxes:

    • Add “Insert Date” to the context menu
    • Add “Insert Time” to the context menu
    • Add “Insert Date & Time” to the context menu
  3. Click OK Done.
Add or remove Popup Calendar and Clock from Excel right-click menu

How to embed a date picker into a spreadsheet

Try theEmbedded Calendarfeature. You can embed the Calendar into a workbook, and it will be available to other users of the workbook.

Any questions or suggestions?
close window
How can we help?