Follow these simple steps to add a datepicker / date dropdown for the whole column in your Google sheet. You can also have the date picker only for the specific rows you need.

  1. Select the whole Column you want the date picker on.

    Date picker for Google Sheet

  2. Then click Data > Data validation

    How to add date dropdown in google sheet

  3. In Cell range: input change the range for which you want the date picker on. Leave it as it is if you want the date range for whole column. You might want to skip the first row, B1 in the screenshot below as if the title row.

    Date picker in google sheet

  4. In Criteria select Date from dropdown menu.

  5. Click Save. Now when you double click on any cell in the column you’ll get the date picker.

    simple date drop down on google sheets

comments powered by Disqus