uboche wrote:curtterp wrote:Just uploaded to the Gallery "WeekByDate"
it has 30 years of dates and week of the year
Are your week numbers ISO or US American?
Whatever Microsoft uses in their Excel built in formula..... I have no idea which it is
uboche wrote:curtterp wrote:Just uploaded to the Gallery "WeekByDate"
it has 30 years of dates and week of the year
Are your week numbers ISO or US American?
uboche wrote:The WEEKNUM function in EXCEL 2010 and later das two arguments:
WEEKNUM(serial_number,[return_type])
If you specify WEEKNUM(serial_number,1) or just WEEKNUM(serial_number), you get US American week numbers.
If you specify WEEKNUM(serial_number,21), you get ISO week numbers which are used across Europe.
System 1 The week containing January 1 is the first week of the year, and is numbered week 1.
System 2 The week containing the first Thursday of the year is the first week of the year, and is numbered as week 1. This system is the methodology specified in ISO 8601, which is commonly known as the European week numbering system.
In addition: In the US, weeks start on Sunday. In Europe, weeks start on Monday.
royaltiger wrote:Formula Description Result
=WEEKNUM(A2) Number of the week in the year that 3/9/2012 occurs,
based on weeks beginning on Sunday (default). Week 10
=WEEKNUM(A2,2) Number of the week in the year that 3/9/2012 occurs,
based on a week beginning on Monday (the second argument, 2). Week 11
Hope this helps
Return to HanDBase General Discussion
Users browsing this forum: No registered users and 2 guests