This video explores several ways to use the FILTER function with Date and Time stamps (DTS) in Google Sheets.
To play along grab a copy of the starter sheet here:
https://yagisanatode.com/google-sheet...
We start off by finding a specific Date Time Stamp from a cell reference and then dive into using the VALUE function to reference a DTS within a formula. Next, we will FILTER Date Time Stamps before or after a value or between two values.
Finally, we have a BONUS section where we use FILTER to filter any DTS after a specific time.
To the written tutorial: https://yagisanatode.com/google-sheet...
00:00 Intro setup
00:51 Range equals cell reference
02:23 Range equals formula VALUE
05:37 Range before or after DTS cell reference
06:13 Range before or after formula VALUE
07:37 Range between two Date Time Stamps cell ref
08:43 Range between two DTS with VALUE
10:01 Range after a time
** My Site **
https://yagisanatode.com/
** More on Google Sheets **
https://yagisanatode.com/google-sheets/
** The Named Functions Pack **
https://yagisanatode.com/products/nam...
Courses *
https://yagisanatode.com/products-cat...
Google Workspace Tools *
https://yagisanatode.com/products-cat...
Google Workspace Add-ons *
https://yagisanatode.com/products-cat...
#GoogleSheets #googleworkspace #spreadsheets #businessadministration #admin #businessmanagement