Calculate calendar week in SharePoint column

Question

I would like to calculate the KW from the created date.
Anyone know a way?

Answer 1

Hi @Enrico Kreisig ,

I used the following formula. Week starts on Monday. Depending on your regional settings you have to replace it.

=IF(INT((StartDate-DATE(YEAR(StartDate);1;1)+(TEXT(WEEKDAY(DATE(YEAR(StartDate);1;1)-1);"d")))/7)=0;52;INT((StartDate-DATE(YEAR(StartDate);1;1)+(TEXT(WEEKDAY(DATE(YEAR(StartDate);1;1)-1);"d")))/7))  

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi,

Please try this formula or check the post from the official forum to create a calculate column using the required date:

=INT((Today()-DATE(YEAR(Today()),1,1)+(TEXT(WEEKDAY(DATE(YEAR(Today()),1,1)),"d")))/7)-INT(([Column Name]-DATE(YEAR([Column Name]),1,1)+(TEXT(WEEKDAY(DATE(YEAR([Column Name]),1,1)),"d")))/7)

Post:
https://answers.microsoft.com/en-us/msoffice/forum/all/calculate-week-number-in-sharepoint-list/ff8126e0-e4a5-4626-93bc-c932a4473a69

Hope this helps.

Regards.

JM

Answer 3

Hi @Enrico Kreisig ,

Please try to use this:

=ROUNDUP(DAY(Created)/7,0)  

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 4