Google Sheets FILTER function and Dates
This tutorial covers how to filter dates in Google Sheets with the FILTER function. If you want to play along grab a copy of the starter sheet here:
https://yagisanatode.com/google-sheet...
We will kick off with filtering a matching date from a cell reference and then look at the DATE and DATEVALUE functions to filter inline. Then we will run through some examples of using Google Sheets FILTER with dates to display dates before or after or between a date.
To the Written Tutorial! : https://yagisanatode.com/google-sheet...
00:00 Intro setup
00:20 Range equals cell reference
01:31 Range equals DATE function
04:39 Range equals DATEVALUE function
05:42 Range greater or less than cell ref
06:38 Range greater or less than DATEVALUE
07:55 Range between 2 dates cell reference
09:10 Range between 2 dates DATEVALUE
** 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
En esta página del sitio puede ver el video en línea Google Sheets FILTER function and Dates de Duración hora minuto segunda en buena calidad , que subió el usuario Yagisanatode -Scott- 21 febrero 2024, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 10,441 veces y le gustó 57 a los espectadores. Disfruta viendo!
