I need to sort/subtotal/analyze data based on week of the year. I'm familiar with the WEEKNUM function...but I need to sort etc by a Work Week that begins on Saturday. The options for WEEKNUM seem to be a week that begins on Sunday (1) or Monday (2). Can anyone offer some help on how to sort etc by a Work Week that begins on Saturday?
Using an IF Statement seems to get the result I want:
but was hoping to go through fewer wickets.