Re: [office-formula] WEEKNUM reference

["David A. Wheeler" <dwheeler@dwheeler.com>]

Eike:
> WEEKNUM, as opposed to ISOWEEKNUM, is supposed to return a non-ISO week
> number. As this function is meant to be Excel compatible I assume it's
> some U.S. definition. We should state it for reference, just what is it called?

I don't think there's a single name for this system. Indeed, there are _set_ of such systems, depending on what day your weeks begin at.  It is NOT limited to the US.  This has some useful info:
http://en.wikipedia.org/wiki/Week#Week_number

I propose that we call this the "traditional week number". It simply declares that January 1 is the first day of the first week, and increments on the next beginning of the week (controlled by the second parameter).

Indeed, the Excel formula only allows Sunday and Monday, but it appears that in many Islamic countries the day begins on Saturday.  I believe we should extend that parameter to include ANY day, particularly Saturday, to handle everyone.  That would really improve internationalization.

Eike: Would you please make those changes?

--- David A. Wheeler