Date picker in 365

**Johann Fourie** · 09-23-2018, 04:32 PM

I've updated from Excel 2016 to 365 and I do not find a solution to employ a date picker. Can any person assist me? Thanks

**caveman1957** · 11-20-2018, 10:21 AM

I was told that there is no such thing as a silly question so here goes.
What is a date picker?

**AliGW** · 11-20-2018, 10:22 AM

There is no datepicker available in the more recent versions of Excel.

A datepicker is a little calendar that pops up allowing you to search for and select a date to enter into a drop-down box in a cell or on a form.

**CK76** · 11-20-2018, 10:30 AM

For backward and forward compatibility. I'd recommend using custom calendar code rather than using date picker.

These will travel with workbook (macro enabled or binary format) and does not require user install the control. And compatible with 32/64 bit install.

Few examples:
https://trevoreyre.com/portfolio/excel-datepicker/ - I like this one and use it when I need one.
https://www.myonlinetraininghub.com/excel-date-picker
http://www.yogeshguptaonline.com/201...te-picker.html