Set default date for Excel Date Picker / Pop-up Excel Calendar Skip to main content main content
Sharing is caring

The date picker by default displays the pop-up calendar showing current system date if the target cell does not contain a valid date value or it is blank. This could be very inconvenient if you need to enter many date values that are far from the current system date.

By setting the default date value, the date picker shows specified date on the calendar for the target cell. To open the Default Date dialog box:

  1. Click the Settings button on the toolbar in Excel 2000/2002/2003, or click the Settings button on the ribbon in Excel 2007/2010.
  2. Click the Default Date button.

Set a default date for the date picker

If the text box is left empty and you click OK, the date picker will show current system date when the pop-up calendar shows for an empty cell or a cell does not contain a valid date.

If you enter a valid date value in the text box and click OK, this date value will be shown on the pop-up calendar next time it opens for an empty cell or a cell does not contain a valid date.

If "Restore this setting next time Excel starts" is checked, the default date value set in the text box will be restored automatically next time you run Excel. If this box is unchecked, next time you start Excel the date picker will use the system date again.