Excel Gets a Date Picker

About time, too.

Andrew Moss
2 min readDec 9, 2023

--

Yippee!

Excel finally has a date picker — imitating another Google Sheets feature — except going above and beyond to ensure it’s a cut above.

At the moment, it’s only available to Excel for web users but will inevitably be rolled out to desktop in due course.

The advantage over Sheets’ effort is not only can you hop back and forward a month, but it’s much easier to navigate to older dates.

For example, double-clicking on a cell containing 02/12/2023 displays all the days belonging to the month. However, if you select ‘December 2023’ at the top, this changes to the year’s months. Another click reveals a batch of 12 years.

It’s an extreme example, but the process to reach 01/01/1900 is an arduous task in Sheets. Yes, if you wanted to input a date that old, you’d be better off typing it in, but the point remains.

Previously, we had to rely on the likes of Mini Calendar and Date Picker in the Office Add-ins store, which averages a 3-star rating. Or, my preference, which is available at Rad Sheets

--

--