Excel date picker: insert an excel date picker calendar in a cell

As important as it is to have a calendar option handy for setting appointments, scheduling a meeting and travel dates, why has Microsoft not developed an option to insert the calendar into a cell to pop-up when formatting a date cell/column?

I have gotten a warning "This formula is missing a range reference or a defined name." There is the word EMBED that is highlighted gray in the input bar and it will not let me correct this. How can I resolve this?

Very good! Happy to have subscribed your channel !!!

Just one more basic feature that's nativly and conveniently built into Google Sheets that's missing from Excel. I'm being forced to use Excel for work and it feels like going back in time about 15 years. Excel is a great example of the harm caused by monopolies.

I don't see the MS Date and time picker control

You are legend mate!

Hi, the value stored in the cell is stored as text and not recognized as date. How to solve this?

I'm using 32bit.. I don't have this :(

What if i need to put a calendar in 1000 cells? Or everytime a row is added to my table?

If you're missing the "Microsoft Date and Time Picker Control", be aware that this is not available in the 64 bit version of Excel.

Only works on 32bits...

Awesome video.

Hi, you must say " this solution is valid for office 32 bit only, not for 64 bit"

How did you get the date picker as an option to select from the tools. I am not seeing in my tools

can this type of data pocket be added to a PBI report instead of Excel?

Hi. Thank you for the video, it was really useful and everything worked perfectly well. I was wondering if there was a way to update the min and max date automatically. In my case, I set the maxdate to today and the mindate to one year ago, using the formula today in properties, but it didn't work. Is it possible to link it to a cell maybe?

A1 👌👌

Superb 👍👍

Great stuff thank you

Great thanks, but how do I do it for Excel for Mac?