Skip to main content
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user

Sharepoint SharePoint Online: Calculated field with week number starting Saturday

Source Link

Sharepoint Online: Calculated field with week number starting Saturday

I've found a few ways online to calculate the week number but none that allow me to start the week on Saturday. Here is the formula that I tested, but doesn't give me Saturday-Friday.

=INT(([Time In]-DATE(YEAR([Time In]),1,1)+(TEXT(WEEKDAY(DATE(YEAR([Time In]),1,1)),"d")))/7)+1