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

[TABLE="width: 373"]
<tbody>[TR]
[TD="width: 151, bgcolor: transparent"]

01/01/2019​

[/TD]
[TD="width: 27, bgcolor: transparent"][/TD]
[TD="width: 27, bgcolor: transparent"][/TD]
[TD="width: 27, bgcolor: transparent"][/TD]
[TD="width: 27, bgcolor: transparent"][/TD]
[TD="width: 27, bgcolor: transparent"][/TD]
[TD="width: 27, bgcolor: transparent"][/TD]
[TD="width: 27, bgcolor: transparent"][/TD]
[TD="width: 27, bgcolor: transparent"][/TD]
[TD="width: 27, bgcolor: transparent"][/TD]
[TD="width: 27, bgcolor: transparent"][/TD]
[TD="width: 28, bgcolor: transparent"][/TD]
[TD="width: 28, bgcolor: transparent"][/TD]
[TD="width: 27, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 151, bgcolor: transparent"][/TD]
[TD="width: 27"]

3​

[/TD]
[TD="width: 27"]

4​

[/TD]
[TD="width: 27"]

5​

[/TD]
[TD="width: 27"]

6​

[/TD]
[TD="width: 27"]

​

[/TD]
[TD="width: 27"]

7​

[/TD]
[TD="width: 27"]

1​

[/TD]
[TD="width: 27"]

2​

[/TD]
[TD="width: 27"]

3​

[/TD]
[TD="width: 27"]

4​

[/TD]
[TD="width: 28"]

5​

[/TD]
[TD="width: 28"]

6​

[/TD]
[TD="width: 27"]

​

[/TD]
[/TR]
[TR]
[TD="width: 151, bgcolor: transparent"]

​

[/TD]
[TD="width: 27, bgcolor: transparent"]

1​

[/TD]
[TD="width: 27, bgcolor: transparent"]

2​

[/TD]
[TD="width: 27, bgcolor: transparent"]

3​

[/TD]
[TD="width: 27, bgcolor: transparent"]

4​

[/TD]
[TD="width: 27, bgcolor: transparent"]

​

[/TD]
[TD="width: 27"]

5​

[/TD]
[TD="width: 27"]

6​

[/TD]
[TD="width: 27, bgcolor: transparent"]

7​

[/TD]
[TD="width: 27, bgcolor: transparent"]

8​

[/TD]
[TD="width: 27, bgcolor: transparent"]

9​

[/TD]
[TD="width: 28, bgcolor: transparent"]

10​

[/TD]
[TD="width: 28, bgcolor: transparent"]

11​

[/TD]
[TD="width: 27, bgcolor: transparent"]

​

[/TD]
[/TR]
[TR]
[TD="width: 151, bgcolor: transparent"]

Employee​

[/TD]
[TD="width: 27, bgcolor: transparent"][/TD]
[TD="width: 27, bgcolor: transparent"][/TD]
[TD="width: 27, bgcolor: transparent"][/TD]
[TD="width: 27, bgcolor: transparent"][/TD]
[TD="width: 27, bgcolor: transparent"]

1​

[/TD]
[TD="width: 27"][/TD]
[TD="width: 27"][/TD]
[TD="width: 27, bgcolor: transparent"][/TD]
[TD="width: 27, bgcolor: transparent"][/TD]
[TD="width: 27, bgcolor: transparent"][/TD]
[TD="width: 28, bgcolor: transparent"][/TD]
[TD="width: 28, bgcolor: transparent"][/TD]
[TD="width: 27, bgcolor: transparent"]

2​

[/TD]
[/TR]
[TR]
[TD="width: 151, bgcolor: transparent"]

A​

[/TD]
[TD="width: 27, bgcolor: transparent"]

A​

[/TD]
[TD="width: 27, bgcolor: transparent"]

A​

[/TD]
[TD="width: 27, bgcolor: transparent"]

A​

[/TD]
[TD="width: 27, bgcolor: transparent"][/TD]
[TD="width: 27, bgcolor: transparent"]

3​

[/TD]
[TD="width: 27, bgcolor: transparent"][/TD]
[TD="width: 27, bgcolor: transparent"][/TD]
[TD="width: 27, bgcolor: transparent"][/TD]
[TD="width: 27, bgcolor: transparent"][/TD]
[TD="width: 27, bgcolor: transparent"][/TD]
[TD="width: 28, bgcolor: transparent"][/TD]
[TD="width: 28, bgcolor: transparent"][/TD]
[TD="width: 27, bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]
If not possible I will think of another solution.

 

[Godders199]

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