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
Nesta página do site você pode assistir ao vídeo on-line Google Sheets FILTER function and Dates duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário Yagisanatode -Scott- 21 Fevereiro 2024, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 10,441 vezes e gostou 57 espectadores. Boa visualização!
