Is there an easier way to add a filter with days instead of dates?


I currently have a line chart widget that tracks count of a value weekly. The only problem is that our week starts on Friday, ends on Thursday of the following week.

I have set up helper columns with a formula =WEEKNUMBER([NEO date scheduled]@row) but on every Friday, i have to change =WEEKNUMBER([NEO date scheduled]@row) + 1. I though setting this on change cell value automation for Friday only, but smartsheet doesnt seem to add formulas on automation.

If there is not an available feature to set a filter range for days, hoping it can be a feature added?