How to Add a Calendar Date Picker in Google Sheets

A data picker provides a quick and convenient way of entering dates in your worksheet. Fortunately, Google Sheets provides two ways of displaying a calendar date picker.

Method 1

  1. In the cell that you want a date picker to appear in type @date
  2. Now select Date in the menu
  3. A calendar date picker will appear – select the required date and that date will be stored in the cell

Method 2

This method uses data validation.  It can be applied to many cells at once.

  1. Select the cells that you want a date picker to appear in
  2. Click on Data to open the Data menu (across the top of the worksheet)
  3. In the menu select Data Validation
  4. A task pane will appear on the right of your screen titled: Data Validation Rules
  5. Click the +Add rule button
  6. In the Criteria drop-down select Is Valid Date
  7. Select Reject the input in the If the data is invalid section
  8. Click on Done
  9. Double-click on a cell that the data validation has been applied to and a calendar date picker will appear.

 

Leave a Comment

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

Scroll to Top