Get week number but week starts with Saturday

[Monica_]

Hello,

We are currently building a workflow which gets the week number. But a week must be from Saturday to Friday. Any possible solution for this? Thanks.

[PanPP · Accepted solution]

Hi @Monica_ 

I would recommend using this community post to calculate the week number with your specific days that make up the week. 

Download the workflow posted by JohnJPS - In his workflow, you can modify the IsoWeekDay column/expression.

Hope this helps, if it does please like this post/mark it as a solution.

[Felipe_Ribeir0 · Accepted solution]

Hi @Monica_ 

See if this works for you.

[Monica_]

I also had these formula:

IF [Day] In ("Sat", "Sun")
THEN ToNumber([Week_Number_Default]) +1
ELSE [Week_Number_Default]
ENDIF

Thanks for all the help everyone! 😀