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:


    • Mike Benny says:

      To change the format of the date, select the date cells (or column) and click Format (from the main menu). From the drop-down select Number and select from the date formats shown.

Leave a Reply

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