ISO Week Number Calculation

[MariusUz1]

Hello everyone! 

I have searched the community to find a solution for our problem, but I think I did not find anything matching it just yet. 

We are using the following calculation to identify the week number (taken from: https://experienceleaguecommunities.adobe.com/t5/workfront-questions/week-number-calculation/m-p/500...)

ROUND((((DATEDIFF({entryDate},DATE(CONCAT("1/1/",YEAR({entryDate}))))+1)-(8-DAYOFWEEK(DATE(CONCAT("1/1/",YEAR({entryDate})))))-DAYOFWEEK({entryDate}))/7)+2,0)

Our problem is, that DAYOFWEEK is not following the ISO-Week format, meaning it considers Sunday as the first day of the week.

Does anyone here know how to adjust the formula above to match the ISO-Week format? 

Any help would be very much appreciated!

Best,

Marius

[monicacardoso · Accepted solution]

Hi @MariusUz1,

Thank you for your question! Try this: 

ROUND((((DATEDIFF({entryDate},DATE(CONCAT("1/1/",YEAR({entryDate}))))+1)-(9-MOD(DAYOFWEEK(DATE(CONCAT("1/1/",YEAR({entryDate}))))+5,7))-MOD(DAYOFWEEK({entryDate})+5,7))/7)+2,0)

- Monica