Formula calculated column: show date as week number

Occasional Visitor

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 17 column WeekBN 


1 Reply

@Gogi_Putkaradze you can do this with the following formula. Change Alert to Salesweek:




Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)