Forum Discussion
Solved
Have Week Start on Saturday in Date Column
Hi there, I am looking to create weekly buckets to sort data within a date column, so that the week starts on a Saturday and ends on a Friday. For example: Saturday, October 1, 2022 through Frida...
Thanks for the clarification Greg_Deckler ! I was able to get the same results using "+1" at the end of formula instead of "-1"
Using 16 as the second parameter of weekday returns Saturday = 1 and Friday = 7.WEEKDAY('Date'[Date], 16)
Thanks for the clarification Greg_Deckler ! I was able to get the same results using "+1" at the end of formula instead of "-1"