the article you point to does give you the correct information, but made it a bit hard to find the essential formula:
WeekOfYearFiscal( Date , 2 )
This will give you the ISO-weeknumber. (The date must be an actual date)
Thanks for your comment.
That does it. Many thanks and best wisches!
Sometimes week number isn't enough. For example, finding week 40 will find week 40 in every year. And specifying the year doesn't help, and sometimes the date (eg: 1/1/1993 ) will return the correct week (week 53) but it is classed as being in 1992, so adding a year to the search criteria doesn't work.
I use this to generate at 'fully'qualified' week number, in the format YYYY-WW
/ Substitute the correct date field for MyDateField in the Let function
[ Date = MyDateField ] ;
WeekOfYearFiscal ( Date ; 2) > 51 and Month ( Date ) = 1 ;
Year ( Date ) - 1 ;
If ( WeekOfYearFiscal ( Date ; 2) = 1 and Month( Date ) = 12 ; Year( Date ) + 1; Year( Date ) )
& "-" &
Right ( "0" & WeekOfYearFiscal ( Date ; 2 ) ; 2 )
Also many thanks for this supplement and again the very best wishes