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
