This blog is moved to
http://amalhashim.wordpress.com

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 :)

2 comments:

fiskit said...

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.

Unknown said...

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