Parse rows by date filter (Google Tables)

Question

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.

Answer 1

See if this helps

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