Date Dropdown

Copper Contributor

Hi, I wanted to know how to create a date dropdown / calendar in an excel cell. I tried all possible ways to get it done, but nothing works for me. Please guide and help.

 

Thank you

3 Replies
The basic answer is that it isn't a 'standard' built in ability. However, it is possible and there are many sites with instructions and videos. Here is one: https://www.extendoffice.com/documents/excel/2437-excel-drop-down-list-calendar.html If that isn't working or what you are looking for maybe you can give us a little more information.

@mtarler the problem is, that "microsoft monthView controll" isn´t in the menu. I can´t find it...

@LucAssmann 

Not really a dropdown, but an alternative: see Excel Date Picker