How to Add and Display Date Picker Option in Google Sheets

Hello and welcome to TeqTog once more! For the topic of this article, I have chosen to explain to you how you can add and display the date picker option in Google Sheets.

Let’s begin, then!

Inserting Date Picker in Google Sheets: Why you need to

You probably already know that having a popup fitted in your spreadsheet can be super convenient as it allows you to choose the date from real-time calendars; rather than typing a date and then applying the correct date format to it.

If you think that that is about it, then you should know that there are a few other great benefits to having this neat feature and before you get to add it to your spreadsheet, you should be well aware of the other ways you can make use of it.

  1. The date picker always option makes sure that the date you have is in the accurate format.
  2. You can quickly check what day you are running of the week before you type it in.
  3. You can easily go over the number of days the month (in question) has or, the number of days before and after your required date.
  4. You can easily check the number of days it will take before the month ends.

How to Add the Date Picker Option in Google Sheets

These are the steps shown below in my example; to adding the date picker option, or, the popup calendar option in your Google Sheets:

  • First, start by selecting the range of cells (or just the cell), for which you want the date picker option to work.
  • Next, find the “Data” option from the top menu and click on it.
  • From the drop-down menu, select “Data validation”.
Under the drop-down menu Date select on Data Validation option
  • By doing this, a dialogue box named “Data validation” will open up.
How to Add the Date Picker Option in Google Sheets

You should see the drop-down menu right next to the option that says “Criteria”? You need to click on that. From the options, click on the one which says “Date”.

From the options click on the Date
  • For the “On invalid data” menu, click on the option that says “Reject option”.
  • The last thing to do now, is to click on the “Save” button.

Making Calendars Appear in Google Sheets: Alternative

Normally, there is another way in which you can make the Google Sheets calendar appear:

You need to have a date inserted in a cell and make sure that it is in the correct date format. You can change formats by going to the “Format” menu and selecting “Number” > “Date”. Now if you just double-click on the cell containing the date, the Google Sheets calendar will pop up.

However, for this process to work, you need to have a date already inserted in a cell; and, from the method that I have shown you here, you can make the calendar (or, date picker) appear even if the cell is empty.

Closing Thoughts

Well, that pretty much wraps it up on how to add and display the date picker in Google Sheets. I hope this helps you.

Best of luck!

Read Our Few More Google Sheet Guide On:

How to Compare Two Dates in Google Sheets

How to Use the ISDATE Function in Google Sheets

Google Sheets Script 101: Beginner’s Guide

How to Calculate Time in Google Sheets

Was this article helpful?
YesNo


Related More Articles

Leave a Comment