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
Смотрите видео Google Sheets FILTER function and Dates онлайн, длительностью часов минут секунд в хорошем качестве, которое загружено на канал Yagisanatode -Scott- 21 Февраль 2024. Делитесь ссылкой на видео в социальных сетях, чтобы ваши подписчики и друзья так же посмотрели это видео. Данный видеоклип посмотрели 5,539 раз и оно понравилось 43 посетителям.
