Skip to content

Pick a Date From the Calendar

Google Sheets has a lot of hidden features. Here is a nifty feature in Google Sheets that you probably were not aware of.

Once you have entered a date into any cell in Google Sheets, you can change this date by picking a new one from the Calendar picker tool.

How does this work? Read more to find out.

Change an Already Existing Date

Google Sheets makes it easy to change a date that’s already been entered into the spreadsheet.

All you have to do is double-click the cell containing the date to bring up the Calendar picker tool.

Now all you have to do is use your mouse to select the date you want, and the date value updates within the cell.

Add the Date Picker to Empty Cells

Now how do you enable the Date picker feature for cells that do not already contain dates? All you have to do is use Data Validation.

To apply the Date picker feature to empty cells in anticipation of accepting date values in the future, start by selecting those cells.

With these cells selected, use the Google Sheets menus to select Data > Data Validation.

In the Data Validation window that appears, set the Criteria to “Date,” and set On invalid data to “Reject input.”

Go ahead and click on save, and now anytime you double-click on one of the empty cells containing the data validation you just set up, the Calendar picker tool will appear.

How cool is that?

We hope you learned something new! Thank you so much for reading, and be sure to comment below with any questions, thoughts, or ideas you’d like to share!

This Post Has 3 Comments

    1. To input a date into Google Sheets, simply type the date into any cell. It will then be stored as a date. From there, you can then use Number Formatting to change it’s appearance as there are many ways to format your dates in Excel.

      I hope this helps!

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top