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 :)
Wednesday, October 28, 2009
Subscribe to:
Post Comments (Atom)
skip to main |
skip to sidebar
Code snippets and technology news that come across my daily life.
This blog is moved to
http://amalhashim.wordpress.com
http://amalhashim.wordpress.com
2 comments:
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.
Is start of week monday or sunday? I need monday to be start of week.
Post a Comment