Date and Time Functions

In this video we look at some Google Sheet Date and Time functions for various tasks. -- Current Section: ➡️Section 5: Numbers https://docs.google.com/spreadsheets/d/1FsoYxdQImDyBMHcqtqw0NBhQbQcPNyg67tXYd8qw0gs/copy Previous Sections: ✅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 ✅Section 4: Sharing https://docs.google.com/spreadsheets/d/1cqc0-arYUW-lLGnhkr4mrcwarRupyavHjJ4c6RmDfCE/copy -- 🗣️Socials: WEBSITE: https://matttechtidbits.github.io/matttechtidbits/ REDDIT: https://www.reddit.com/user/MattTechTidbits INSTAGRAM: https://www.instagram.com/matttechtidbits/ Need a Freelancer? Check out my Upwork Profile: https://www.upwork.com/freelancers/~01e15eefe1443fcea1 – ⏳Timestamps: 00:00 Introduction 01:45 Dates vs. Timestamps 03:12 Calculate Days Opened Between two Dates 04:14 Find Days of the Week Trends 06:20 Find Week and Month Trends 11:49 Month and Year Trends 16:26 Bonus: Pull Timestamps from Any Dates? 17:23 Conclusion 17:59 End Slides 🎵Music is "WFH" made by me with my solo music project name, Ambiosynthesis https://www.youtube.com/watch?v=sKi5cGTQoBM — #sheets #spreadsheet #googlesheets #technology