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
4 Likes
That’s worked well, thanks!
1 Like
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.