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
Sur cette page du site, vous pouvez voir la vidéo en ligne Google Sheets FILTER function and Dates durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur Yagisanatode -Scott- 21 février 2024, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 10,441 fois et il a aimé 57 téléspectateurs. Bon visionnage!
