Wednesday, October 28, 2009

Sharepoint Calculated Field - Week Number

The following formula will help us to find the week number for a date value.

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

Hope this helps :)
at

2 comments:

  1. fiskitJune 20, 2011 at 7:41 AM

    Do you have an updated formula for 2011 with the first week of the year being the first four day week?

    I beleive this is what I need to be in sync with my customer in Germany.

    ReplyDelete
  2. UnknownJuly 4, 2014 at 2:04 AM

    Is start of week monday or sunday? I need monday to be start of week.

    ReplyDelete