
How to get a date picker in a Google Sheets cell
I recently learnt a nifty trick in Google Sheets that will force a cell to display a pop-up date picker box when you double click on it. This is a great alternative to typing in dates manually! The secret is to use the Data validation feature to limit the cell data to dates only.