'Parse rows by date filter (Google Tables)

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.



Solution 1:[1]

See if this helps

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

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 JPV