VBA to autofilter by current week number

[Godders199]

Hello, I am trying to work out if this is possible, cantfind when googling but might be using the wrong terminology.
I have the following workbook set up, what I want toautomate is, for excel to calculate the week num and then filter the columncontaining that value. , so in theexample below, on the 01/01/2019 it would autofilter G4 containing 1 07/01/2019 it would autofilter O4containing 2 etc

01/01/2019​

3​

4​

5​

6​

​

7​

1​

2​

3​

4​

5​

6​

​

​

1​

2​

3​

4​

​

5​

6​

7​

8​

9​

10​

11​

​

Employee​

1​

2​

A​

A​

A​

A​

3​

<tbody> </tbody>

If not possible I will think of another solution.

 

[Godders199]

Sorry this concept wont work, no replies needed, i need to think again