Forum Discussion

Nicolas94h's avatar
Nicolas94h
Copper Contributor
May 20, 2024

Return cells within a specific date range (today-6 weeks ahead)

Hello, I have made my own "search bar" in excel with the help of the formulas: Filter, Isnumber and Search.  This gives me a dynamic array where it will always update according to my master sheet...
excel
OliverScheurich's avatar
OliverScheurich
Gold Contributor
May 20, 2024

Hello Nicolas94h,

you are welcome. I've made up a sample table with your data and hope this formula works for you.

 

=FILTER(Orders,

(Orders[Date]>=TODAY())*

(Orders[Date]<=TODAY()+42)*(ISNUMBER(SEARCH(D3,Orders[ORDRE]))+ISNUMBER(SEARCH(D3,Orders[KUNDE]))+ISNUMBER(SEARCH(D3,Orders[[Spærret ]]))+ISNUMBER(SEARCH(D3,Orders[[ETD HEDENSTED ]]))),

"No Match")

Nicolas94h's avatar
Nicolas94h
Copper Contributor
May 20, 2024

Hello OliverScheurich,

 

Thank you for your quick answer and your examples.


I don't know how to insert an Excel file in my message to you, so I have inserted a picture instead.

Please see picture below:

 


I have changed the column order in your Excel sheet to give you a better understanding of how my original table is structured. 
As you can see in the attached picture above, the dates I want to return are not in the first column.


Will this formula still work ?
Can you please change the formula?

I apologize for the many questions.

 

Resources