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.
But I have the need to search find cells that fall within a specific date range, precisely today-6 weeks ahead.

Is there a way for me to be able to find these cells that fall within this timeframe? Where it will also be dynamic and show the whole rows as well.

Please help.

Thank you in advance.

​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.But I have the need to search find cells that fall within a specific date range, precisely today-6 weeks ahead.Is there a way for me to be able to find these cells that fall within this timeframe? Where it will also be dynamic and show the whole rows as well.Please help.Thank you in advance.  Read More

​