How to add a date picker to a Google Spreadsheet

Here’s how to add a date picker to a Google Spreadsheet…

Select the cell (or the row, or column) and set the “format” to “date”.

Adding a date picker

Double-click the date and there’s your date picker!

Did it 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.

  1. Morten Meyer says:

    Hi. This works wonderfully when using the spreadsheet on my PC. I also need to be able to enter dates from an android smartphone using chrome and from an Iphone/Ipad using the sheets app or a browser. But no datepicker shows up when I click on a cell to enter a date. Do you know how to open the datepicker on ios and android? It is probably jest a user error on my side – please help if you can. Thanks a million.

    • Mike Benny says:

      Hi Morten,

      Try selecting the cell and then look for a little calendar icon.

      Date picker Android

      This is from my Android, but I’m sure iOS would have something similar.

      Please let us know if this works.

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.