you could prevent such situations by using a date picker.
To do this, pick the cell where you want to insert the date picker.
Then, bang out in any valid date format in that cell.
Aman Kumar / How-To Geek
tap the cell and choose “Format” from the top bar.
Choose “Number” and then select “Date” from the menu that appears.
And that’s it!
The selected cell is now converted to the date format.
What if you want to keep the cell empty and allow users to input a date themselves?
In Google Sheets, grab the cell or range of cells where you want to initiate the date picker.
Click “Add Rule.”
choose the drop-down icon for the “Criteria” option and select “Is Valid Date.”
Choose the “Reject the Input” radio button under the “If the Data Is Invalid” option.
Finally, click “Done.”
The pop-up calendar will now appear whenever you double-hit the formatted cells.
That’s how you insert a pop-up date picker in Google Sheets.
Wasn’t it quick and easy?
Now that you know that, consider exploring differentdate and time functions in Google Sheetsto improve your productivity.
