Add 'date picker' to enable users to select a date from a mini calendar into cells
Figures
shared this idea
Hi all,
We have been working on this, and wanted to get your feedback on how you see this feature fitting into your workflow. We have a quick one question survey for you to give us your thoughts on the look and keyboard shortcuts we have at this time. Please see here for more: aka.ms/datePickerSurvey
Thanks!
Blake, Excel Product Team
1469 comments
-
Craig Spakowski
commented
Hello Microsoft Admins. Please return the Date Picker for Office 365 64bit.
-
Peter
commented
The most irritating part of this is that there WAS a very good and perfectly functional date picker already incorporated into coded workflow that was removed by MS when it was presumably 'too hard' to convert from 32 to 64 bit. A real shame when MS stuffs up good features within their own flagship products. If anyone in MS is actually listening (clearly not?!) then please return this functionality through VBA while your adding a date picker (back) into standard Excel.
-
Anonymous
commented
It has been more than 5 years, since we requested this, is that difficult to add this function ?
-
Dave K
commented
I just subscribed to Microsoft 365 and am disappointed to find that this is not built in. The main thing to me is it would help to take the guesswork out of the "is it supposed to be mmddyy or ddmmyy" (or some other format) conundrum. The add-in available from the Microsoft Store seems unwieldy to me and clutters things. Ideally you would be able to format cells as datepicker cells and so whenever you click on the cell it would bring up a date (and maybe time) selection control, eliminating the date format guesswork and also speeding workflow.
-
Anonymous
commented
I note that they asked for feedback 3 years ago and have done nothing to make this application work on 64K machines; so why ask if you have no intention of acting? 90% of the functionality of Excel is for applications that very few people use, and that's great, but something like an embedded calendar would be useful to a high percentage of users, so why has it been abandoned?
-
Kux
commented
Is there an update re the date picker function?
-
Lyn
commented
"Date Picker Tool" is essential for the work I want to do and previous versions that we had made it easy to insert a Date picker into our forms. I think it would have been nice to know what a pain this is in the 64 bit versions of Office and maybe a warning before upgrading from 32 bit to 64 bit would not be worthwhile.
-
SWalter
commented
Approaching 3 years since the last "Started" update?
What is considered a "Basic" function fumbled by Microsoft.....and seemingly no urgancy to bring it back.
-
Steve
commented
How can this not be a feature already in (as it was once before) Excel???
-
Ken C
commented
I can't believe this option has been removed - recently had to upgrade to Office 365 and am now considering it to be a backward step!!
-
Anonymous
commented
Please add a date picker in both worksheets and user forms!
-
Laurie
commented
Doesn't look like there has been any progress on this despite the comments and requests for it. It is a vital component of a lot of forms. It really would be great if this could just get done. As it has been previously available on different OS, this should be fairly straight forward.
-
Annette
commented
Come on, folks...it's been 5 years and still nothing? Seriously, this seems like a baseline requirement, how can you get it so wrong for so long?
-
Anonymous
commented
This is a no brainer. I was shocked to find this wasn't just in the standard package.
-
Matthew Winter
commented
5 years on and still nothing from MS. Says a lot really doesnt it?
-
Anonymous
commented
Please add a date picker to excel!
-
Anonymous
commented
What was the reasoning behind removing this useful tool? Instead of removing Date Picker, improve its functionality.
-
Shaun
commented
Very few organizations use 32bit instances of office. Please enable the date picker for 64 bit instances of Excel.
-
Anonymous
commented
I see this tread originated in 2016 ! I guess it just doesn’t have enough votes.
5 years and we still see no date picker. -
tpain
commented
We need the Date picker at wells fargo bank. We have critical tools that use the date picker. It is too risky to have the user of the tool I built (Excel Userform tool) to enter dates manually into a text box. If they enter the date incorrectly it could harm the customer and open Wells Fargo up to litigation, ruin public trust, and get me fired and more... bring it back asap please.