Forum Discussion
Gogi_Putkaradze
Apr 21, 2022Copper Contributor
Formula calculated column: show date as week number
I have the following issue in SharePoint List: I have a column name SalesWeek and I want to show in another column named "WeekNB" the week number. In short show 4/21/2022 in Salesweek as week ...
Nonesbusiness
Copper Contributor
Lev_Kr my network operations team was able to fix the same problem using this code. We are in SP2016, with on prem servers.
=CONCATENATE(TEXT(IF(INT(([Work date]-DATE(YEAR([Work date]),1,1)+(TEXT(WEEKDAY(DATE(YEAR([Work date]),1,1)-1),"d")))/7)=0,52,INT(([Work date]-DATE(YEAR([Work date]),1,1)+(TEXT(WEEKDAY(DATE(YEAR([Work date]),1,1)-1),"d")))/7)),"0"))
SueDickerson
Feb 10, 2023Copper Contributor
While this works, in O365 SharePoint, you cannot filter or group or create a view by the result of the calculation. Very odd!!