How to Display Date Picker in a Google Sheets Cell

13 December 2018
Samantha Garrett

Typing dates manually into Google Sheets is tiresome. There is another way!

Try this nifty trick that forces a cell to display a pop-up date picker box when you double click on it. The secret is to use the Data validation feature to limit the cell data to dates only. A special shout out to the lovely Amy, from our client Snowy Hydro, who shared this tip with me!

Here’s how to set it up:

1. Highlight the range of cells that you want to add a date picker too.
Tip: It’s best to do this before entering any data in the cells.

2. Select the Data menu > Data validation.

3. In the Criteria section, choose ‘Date’ from the drop-down list.

4. In the box that appears alongside ‘Date’, choose if you want to allow any date (leave it as ‘is valid date’) or a specific date range.

5. Click Save.

6. Double click on a cell in the range you added the validation to and watch as the date picker appears!

Visit our Learn on Demand platform to discover more helpful Google Sheets tips and tricks.

Recent Posts

Here’s What
Our Clients Say

PR Industrya


In 2018, Using Technology Better designed and delivered a two phase post-migration training program for this New Zealand based graphic design firm. The initial goal of the training program was to reduce frustration with G Suite, with the long term aim of facilitating a change in culture and collaboration that can lead to transformative practices

Download your skills checklist to see how you score...


Choose Industry:

Which Skills Checklist?


Sign Up Now
To Get The Latest Updates


Pop in your details below and we'll send you the PLD Checklist 📧

First time applying for MoE Funded PLD?

Get the Latest Blog Posts, New Tips And Tricks


NSW DoE Leadership Webinars


NSW DoE Leadership Webinars


Holiday Rescue Maker Camp

Student to agree to and tick:
Guardian to agree to and tick: