weeknum function

[ljoseph]

This is regarding weeknum funtion of excel.
17 sep 2010 is on Wk 37.
But the function weeknum(a1) gives 38 in excel with A1 having 09.17.2010
Where am i making the mistake?

[zbor]

What you get for those days (dd.mm.yyyy):

13.1.2010
12.1.2010
11.1.2010
10.1.2010
9.1.2010
8.1.2010
7.1.2010
6.1.2010
5.1.2010
4.1.2010
3.1.2010
2.1.2010
1.1.2010

[yurttas]

This is regarding weeknum funtion of excel.
17 sep 2010 is on Wk 37.
But the function weeknum(a1) gives 38 in excel with A1 having 09.17.2010
Where am i making the mistake?

Have a look at this link:
http://www.google.com.tr/url?sa=t&so...Rdou_4PUIl0hiQ