The only way I have been able to do this was to create a filter with 2 conditions.  one that has a Starts on or after x date and another that starts on or before x date.

Thanks. But the date you're comparing to is not dynamic, right? So the user has to set the current week, it's not automatically assigned by Airtable.

OK, I was a dumb***. Of course we can still use formulas and have a formula calculate if it is the current week. 

But does the table update itself? So it puts all of the numbers to 0 that were 1 previus week?

Yes 🙂 Airtable formulas are instantaneous

Oh ok thanks helped a lot actually.

I found a problem with this tacric so when a new year starts You will have 2 weeks with the same week number.

You mean that different years can span across the same week?

Yes so next year when the same week comes you will have this week and the same week from a year ago both labeled with 1. Hope that makes sense