Trying to change the start of the pay period from Sunday to Monday.
Yeah, I was bitten by this before thinking WEEKNUM would return a week from Monday to Sunday.
My approach is like this:
1/Add a column to calculate the weekday number of the timestamp
So Sunday returns 1, Monday returns 2 and so on.
2/Add a column to calculate the adjustment value
If the weekday equals 1 (meaning it’s Sunday), return -1. Else return 0.
3/Modify the existing weekcode formula to add the adjustment value
That’s worked well, thanks!