Validating Dates, Creating Date Pickers in Google Sheets and more : Data Validation: Google Sheets

00:00 Intro 00:16 Enter a valid date 00:34 Users entering different date formats 01:04 Formatting data validation cells 01:47 Displaying a date picker 02:49 Enter date equal to 03:41 Enter date before 04:58 Enter date on or before 06:52 Enter a date after 07:20 Enter a date on or after 08:10 Enter a date between 09:20 Enter a date not between 09:56 Wrap up

There is a lot to consider when using date data validation and this tutorial is packed with tips to help you set up your date validation just right.

Here is a link to the accompanying post The Monster Guide to Data Validation in Google Sheets, it has more explanations and links to resources for you! https://yagisanatode.com/2021/01/26/the-monster-guide-to-data-validation-in-google-sheets-free-course/

#GoogleSheets #Spreadsheets #SpreadsheetBasics #GoogleEDU #GoogleWorkspace #DataValidation

Even knowing the basics can really give you the edge and save you a heap of time in the workplace.

If you like the video, check out my website: https://yagisanatode.com/

Here is the link to just Google Sheets tutorials: https://yagisanatode.com/google-sheets/

Sign up for my course: Google Sheets: Learn the Essentials with Three Detailed Projects https://yagisanatode.teachable.com/p/google-sheets

Grab a Google Sheets Shortcuts Mousepad to help you memorise the Shortcuts. https://www.zazzle.com.au/collections/shortcuts_mousepads-119754792503977450 ... https://www.youtube.com/watch?v=QXuysLO2qtI