Skip to main content

Quickly enable date picker (drop down calendar) for date cells in Excel

Kutools for Excel

Boosts Excel With 300+
Powerful Features

In general, you can type in a new date to overwrite the existing one in Excel easily. However, how could you quickly figure out the last Thursday of the current month and type it in? Here, Kutools for Excel released the Date Picker feature to show a drop-down calendar beside the currently selected date cell, so that you can quickly find out the last Thursday of the current month, and click it to overwrite the original date at ease. Moreover, if you have blank cells in date format, you can also use the utility to quickly fill the cells with dates.


 Usage

This section will guide you to enable and use the date picker in Excel.

1. Click Kutools > Content > Enabled Date Picker to turn on the Date Picker feature.

2. Then you can apply the Date Picker feature as follows:
(1) Select a cell in date format to show the calendar icon  right to the date cell.
(2) Click the calendar icon  to show the drop-down calendar.
(3) Select a date in the drop-down calendar, and click the tick icon to fill in the selected date immediately.


 Notes

1. After you select a new date in the drop-down calendar, the date will populate in the original cell. You can click to withdraw and close the drop-down calendar.

2. The calendar icon only appears when you select a cell in date format.

3. The Date Picker feature supports undo (Ctrl + Z).


Productivity Tools Recommended
The following tools can greatly save your time and money, which one is right for you?
Office Tab: Using handy tabs in your Office, as the way of Chrome, Firefox and New Internet Explorer.
Kutools for Excel: More than 300 Advanced Functions for Excel 2021, 2019, 2016, 2013, 2010, 2007 and Office 365.

Kutools for Excel

The functionality described above is just one of 300 powerful functions of Kutools for Excel.

Designed for Excel(Office) 2021, 2019, 2016, 2013, 2010, 2007 and Office 365. Free download and use for 30 days.

Screen shot of Kutools for Excel

btn read more      btn download     btn purchase

Comments (4)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
So to use a date picker, I need to first input a date instead of just selecting one from the calendar?
This comment was minimized by the moderator on the site
Hi there,

For the current version, yes.
But we are working on the feature now, so that the date picker can pop up as long as the cell is formatted as date in the future versions. 馃檪

Amanda
This comment was minimized by the moderator on the site
Bonjour,

Lorsque que j'active le s茅lecteur de date, aucun icones appara卯t...
This comment was minimized by the moderator on the site
Hi there,

After you enable the date picker, you should select a cell that is formatted as date and contains a date. Then the icon could appear, so that you can easily pick another date.

Amanda
There are no comments posted here yet
Please leave your comments in English
Posting as Guest
Rate this post:
0   Characters
Suggested Locations