How to Insert a Date Picker in Google Sheets (With Example)


A date picker in Google Sheets is a calendar that automatically appears under a specific cell when you click on it.

Google Sheets insert date picker

The easiest way to insert a date picker in a specific cell in Google Sheets is by using the Data Validation option in the Data tab.

The following example shows how to use this option to insert a date picker in practice.

Example: How to Insert a Date Picker in Google Sheets

Suppose we would like to insert a date picker into cell B1 of the following sheet:

To do so, click on cell B1, then click the Data tab, then click Data Validation from the dropdown menu:

In the Data validation rules panel that appears, click Add Rule:

Then click the dropdown menu under Criteria and choose Is valid date:

Lastly, under the section called If the data is invalid click the button next to Reject the input, then click Done:

Now, when you click on cell B1 a date picker will automatically appear where you can click on any valid date you’d like to use in the cell:

Google Sheets insert date picker

Additional Resources

The following tutorials explain how to perform other common operations in Google Sheets:

Google Sheets: How to Use an IF Function with Dates
Google Sheets: Calculate Years Between Two Dates
Google Sheets: How to Generate Random Dates

Featured Posts

One Reply to “How to Insert a Date Picker in Google Sheets (With Example)”

Leave a Reply

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