How To Add Date Selection To Google Sheets

Google Sheets has a built-in date picker (interactive calendar) in all cells. That means to become appointment picker in Google Sheets, there is no official or tertiary party plugin or script required.

Double click any prison cell containing a engagement. This will popup an interactive calendar in Google Sheets.

From this calendar, you lot tin can browse through months and choose the date to insert. But do note ane affair. You lot won't go engagement picker in all the cells containing dates! At that place is i condition.

If the date is the output of any formula like today(), Google Sheets won't popup the appointment picker upon a double click.

What about getting an interactive date picker in blank cells?

If you desire to get date picker in blank cells, that may be a common requirement, follow the below steps.

How to Get Date Picker/Calendar in Google Sheets

Here are the steps to get a clickable (interactive) agenda in a blank jail cell in Google Sheets. Actually, it but involves Google Sheets Information Validation.

Trending: The Best Data Validation Examples in Google Sheets.

Scenario:

I want to let a user select a start date in 1 cell and an end appointment in another prison cell with the aid of date pickers.

Why don't I let the user direct enter the start and end dates? Is at that place any benefit of using the said interactive date picker in Google Sheets?

Yes! Here are the benefits.

It ensures the entered/inserted date'due south format is a valid engagement, not a text.
Before inserting the date that the user wanted, he tin can make sure that whether the date falls on weekends or weekdays.

Screenshot: Date Picker in a Blank Jail cell.

Date Picker in Blank Cell in Google Sheets

Steps:

Click the jail cell or highlight to select the range in which you want to enable the clickable agenda aka date picker. I am going to enable the appointment picker in cell C2 (it'southward my start date input cell).
So go to Data (card) > Information validation.
Select criteria as 'Date' and on the next field select "is a valid date".
Click/enable "Reject input".
If yous desire, type the "validation text" that you want.
Click 'Save'.

Data Validation for Interactive Date Picker

Double click the prison cell C2 to go the date picker. As mentioned, I am going to utilize cell C2 equally my start engagement input cell.

I can follow the same steps in any other cell to get one more cell with the (double click) agenda pick to insert an finish appointment.

Conclusion

I know most of you are familiar with how to get date picker in Google Sheets. Withal, I took the time to write this mail service hoping a few of you may are not well conversed with information technology.

Also, I am going to use this in my next tutorial (a template for date based conditional formatting) to let users select a first and finish appointment to populate a date sequence.

In that tutorial, instead of detailing the process, I can link to this page.

Thanks for the stay. Enjoy!