SharePoint miscalculates the week number.

[keyra]

Hello everyone and a happy new year!

I have in SharePoint a column with the formula below which calculates the week number based on another column (Date Réelle (Fin action).

=IF(INT(([Date Réelle (Fin action)]-DATE(YEAR([Date Réelle (Fin action)]),1,1)+(TEXT(WEEKDAY(DATE(YEAR([Date Réelle (Fin action)]),1,1)-2),"d")))/7)=0,1,INT(([Date Réelle (Fin action)]-DATE(YEAR([Date Réelle (Fin action)]),1,1)+(TEXT(WEEKDAY(DATE(YEAR([Date Réelle (Fin action)]),1,1)-2),"d")))/7))

It worked very well until this year. In 2024 for example the day 15 Jan 2024 which is Monday it's alocated to week 2 instead of 3. and so on each week starts with Tuesday (Mondays reamain to the previous week). Cand someone please help me adjust my formula?

Thank you!

 

[gplhl]

I have had this problem before and had to change by adding or subtracting 1 on the sharepoint file, becomes a problem if people open on desktop app. Similar issue exists with working out week numbers using Power BI

 

[keyra]

I have had this problem before and had to change by adding or subtracting 1 on the sharepoint file, becomes a problem if people open on desktop app. Similar issue exists with working out week numbers using Power BI

i tried that with no success, however i just replace 7 with 6 and now seems to be working ok. thank you for the suggestion