How to add filter to see tasks by weeks number

[Summer2021]

Dear All,

I couldn't find the answer in the forum, so creating a new thread hoping that someone will notice it Could you please share with me your opinions on how to solve this problem.

I am creating a Task tracker for my team (10 people). There are 10 sheets for everyone to fill their tasks and one main sheet (KUS) with a main data table, where all teams tasks appear. Could you please advise me how can I create a possibility to filter and see tasks in the main data table by week numbers. Weeks with numbers and dates entered above the table.

Thank you very much in advance for your time and have a great friday!

 

[Peter_SSs]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: How to put a filter by weeks?
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.