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!
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.