Home > database >  Parse rows by date filter (Google Tables)
Parse rows by date filter (Google Tables)

Time:04-27

How could I parse rows from my table by dates (logic for example: today is 3 more days until the delivery date) and place it into another sheet?

https://docs.google.com/spreadsheets/d/1TTbIX3qNKXyQAQiJ2EuRNDKWy1YEhLBPzsVw8mxMhKs

I need to run this script automatically (or manually) every day to update a list.

CodePudding user response:

See if this helps

=filter(A2:C; C2:C-today() <=3)
  • Related