Number Data Validation Rules

In this video we work through the Number Data Validation Rules! This covers both Dates and Numbers. Similarly to the Text Data Validation Rules, there's a formula to mimic the TRUE/FALSE rules Data Validations Use. ⏳Timestamps: 00:00 Introduction 01:12 Is Valid Date 01:47 Date Is 02:31 Date Is Before 03:09 Date is On or Before 03:41 Date is After 04:01 Date is On or After 04:22 Date is Between 06:41 Date is Not Between 07:12 Number Validations Greater Than 07:34 Greater Than or Equal To 07:44 Less Than 08:03 Less Than or Equal To 08:27 Is Equal To 08:47 Is Not Equal To 08:58 Is Between 09:15 Is Not Between 9:26 Use a Cell Reference Instead of Hard Coding a Number 11:03 Formulas to Consider For Dates 16:15 Formulas to Consider For Numbers 17:39 When to use Data Validations Vs. Functions 19:30 Conclusion and Challenge 21:14 End Slides -- ✅Section 1: Organization https://docs.google.com/spreadsheets/d/1SbRW5LJS5P1A5ZA1hxZv3Hnv3bos-dl-e0F96KCuLrA/copy ✅Section 2: Formula Building https://docs.google.com/spreadsheets/d/1nQF5cN3F_QienoZ2hK87L_xoC0Rc8apNrm7PVA5LaHo/copy ➡️Section 3: Data Validation https://docs.google.com/spreadsheets/d/1kA9gqFX1d-tAA-y6vWUHAtS9xglwCOAx2XuHodrkkJc/copy -- 🗣️Socials: WEBSITE: https://matttechtidbits.github.io/matttechtidbits/ REDDIT: https://www.reddit.com/user/MattTechTidbits LINKEDIN: https://www.linkedin.com/in/matthew-klemme-ba9126b2?trk=pub-pbmap INSTAGRAM: https://www.instagram.com/matttechtidbits/ Need a Freelancer? Check out my Upwork Profile: https://www.upwork.com/freelancers/~01e15eefe1443fcea1 🎵Music is "WFH" by Ambiosynthesis https://www.youtube.com/watch?v=sKi5cGTQoBM — #️⃣ #sheets #spreadsheet #googlesheets #technology