Caluculated Column

Question

I having a dates in the Sharepoint list but I want to get the week number from the dates using the Calculated column.

it's very easy in Excel but hard in the Sharepoint.

Answer 1

Dear Abhinay,

Good day!!

Apologies for the inconvenience caused and please don’t worry, let’s work together on your concern and move towards a resolution path.

I understand your concern and I have done some search, where I found the following formula which helped to get the week number from the date in the SharePoint Online List:

=ROUNDUP((DATEDIF("1/1/"&TEXT([Column with Date],"yyyy"),FROM,"d")+IF((TEXT(WEEKDAY("1/1/"&TEXT([Column with Date],"yyyy")),"d"))="31",1,TEXT(WEEKDAY("1/1/"&TEXT([Column with Date],"yyyy")),"d")+1))/7,0)

**Note:**Please replace [Column with Date] with the name of the Date Column you used in your List.

If there is any misunderstanding or confusion, we apologize and request you to share the more detailed information with screenshots of the problem, where it will help us to better understand and guide you further.

Appreciate your patience and understanding. Have a great day!!

Best Regards,

Sophia

Answer 2

Formula worked, thanks for the help.