Last Updated on November 3, 2023 by Jake Sheridan
How to Display Date Picker in a Google Sheets Cell
The date picker is a handy tool that allows you to select a date from a calendar popup, and enter it into a cell in your Google Sheets spreadsheet.
This can be helpful if you have a cell that contains a date, but you want to make it more user-friendly by allowing your users to select the date from a calendar.
In this guide, we will show you how to display a date picker in a Google Sheets cell.
How to Insert a Date Picker in Google Sheets
Here’s how to insert a date picker in Google Sheets.
First, select the range of cells where you want to display a date picker.
In this example, we’ll add a date picker to column A since it’s already designated to hold date values.
Next, select the Data validation option under Data.
Google Sheets will now show a Data validation dialog pop-up.
In the Criteria section, select Date in the first drop-down menu and is valid date in the second drop-down menu.
You also have the option to choose what happens when the user inputs invalid data.
Google Sheets can either show a warning in the form of a red triangle or reject the input entirely.
Click on Save to apply these changes to the selected range.
Double-clicking on cells in your range should now show a date picker.
The date picker will make it much easier for users to input dates without having to worry about the format.
We can also add further data validation to our date columns.
For example, we can set a specific date range that the user is allowed to input.
Simply select between in the second drop-down list.
Write down the start and end dates of the date range in the provided text boxes.
If the user tries to input a date outside the range, an error will indicate that the date is invalid.
If the user selects the Reject input option, the user will see a error dialog box similar to what is seen below.
The invalid date will not be accepted and the cell will remain empty until a valid date is typed.
This guide should be everything you need to display a date picker in a Google Sheets cell.
You may make a copy of this example spreadsheet to test it out on your own.