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:

 

=INT((Alert-DATE(YEAR(Alert),1,1)+(TEXT(WEEKDAY(DATE(YEAR(Alert),1,1)),"d")))/7)

 

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