How to add a date picker to a Google Spreadsheet

I have been looking for this for a long time. I finally just Googled it…

“Right-click the selection you want to have the date picker show up for (i.e. single cell, entire row, entire column) and then open data validation. Set criteria to A valid date and click Save. Now just double-click the cell!” Here it is!

Date Validation
1. Right-click selection area, select Data Validation, set to “Date”.

Date picker

2. Double-click the cell and up pops the date picker!

Work for you?





Share this:

2 comments

Leave a Reply

Your email address will not be published. Required fields are marked *