Forum Discussion
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 Friday, October 7, 2022 should display October 1, 2022. And Saturday, October 8, 2022 through Friday, October 14, 2022 should display October 8, 2022.
I used the following formula: 'Date'[Date] - WEEKDAY('Date'[Date], 2) - 1, but this did not have the desired outcome because the column is still using Monday as the start day for each week. Additionally, I tried changing the arguements to the WEEDAY function, but it appears I am only allowed to enter in 1 through 3.
Any help with with this would be greatly appreciated.
Thanks for the clarification Greg_Deckler ! I was able to get the same results using "+1" at the end of formula instead of "-1"
4 Replies
'Date'[Date] - WEEKDAY('Date'[Date], 16) - 1Hi Greg_Deckler ,
Thank you for the prompt reply! Unfortunately, the formula provided did not have the desired outcome. I was able to brute force the desired outcome using a long "if" statement.
Thanks again!
Using 16 as the second parameter of weekday returns Saturday = 1 and Friday = 7.
WEEKDAY('Date'[Date], 16)
