Google Sheets FILTER function Dates by Weekday or Weekend

Опубликовано: 14 Март 2024
на канале: Yagisanatode -Scott-

1,010

In this BONUS video on the FILTER function with date and time, we explore how to filter dates by weekdays and weekends in Google Sheets. To the starter sheet!
https://yagisanatode.com/google-sheet...

To accomplish all this we will use the WEEKDAY function, ARRAYFORMULA function and, of course, the FILTER function.

To the written tutorial: https://yagisanatode.com/google-sheet...

00:00 Intro setup
00:35 WEEKDAY function
03:13 ARRAYFORMULA function
04:02 FILTER weekdays
05:29 FILTER weekends

** 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