Weeknum, changing pay period start day


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!

1 Like

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.