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

* NOTE: This video is for the 32 bit version of excel - if you have the 64 bit version, try the second method below.

This beginners tutorial looks at one method of inserting a date picker in excel. Using the developer tab, we show you how to insert a drop down calendar in excel (office 365) and this calendar acts as a date chooser in excel. Also learn how to set a specific date range and link your excel calendar picker to a cell so that you can use the date in formulas.

You can follow along with this tutorial from a blank workbook! Learn this great tip to add a drop down box with a pop-up calendar.

Learn Excel online for free: Our Excel for beginners tutorial will teach you all you need to know to take you from zero to Excel hero!

What Microsoft Excel tips and tricks do you want to learn? Let me know for future videos! I'll continue to develop tutorials covering Excel basics for beginners and will build up a catalogue of free Microsoft Excel course materials! :-)

Check out our other videos and playlists

[robhimself]

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.

[alessandrovilla]

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

[TP]

Straight to point, thanks. Is there a way that we can have this to be within the cell itself, and not as on object like you showed?

[DTA]

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?

[chads-stuff]

The "Microsoft Date and Time Picker" control is no longer included in current 64-bit Office 365 Excel. The instructions in this video won't work.

[haraldskartlandpirolt]

Thank you for an informative video. I just wonder, I have Excel 365, put i don't find "Microsoft date and time picker controle 6.0 (SP4)", even if I open "More controls". Do you know what I can do? Kind regards, Harald

[anthonygikuri]

Thank you for your time. What if I want to have the date picker visible in the entire column

[Matt-rwpy]

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

[josseynon]

Hi - all works - but the calendar moves up and down as I scroll up and down the sheet (it is stuck in a position on the sheet, not hovering and constantly visible) so it basically disappears as I scroll down my sheet. How do I fix this so that the calendar stays in the same place on my screen instead of moving with the sheet?

[javiersantiago]

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?

[moyanmartin]

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

[diamondsandlipgloss]

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

[andrewsvega]

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

[btentertainment]

how to incert date time picker for 300 cells? Do i have to do like this one by one?

[mashudumashathini]

Hi I can't find Microsoft Date n
Mine starts with Microsoft External item picker

[GZus-rgme]

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

[Sean-kwvl]

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?

[johanvorster]

Once I close the file and reopen it, the date picker does not work. Have to go back in design mode, move it and close design mode to get it working again.

[akashpatel]

pleae update for the current excel version

[sailingsolstice]

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.