[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]

*Subject*: **Re: [office-formula] WEEKNUM reference**

*From*:**Eike Rathke <erack@sun.com>***To*: office-formula@lists.oasis-open.org*Date*: Tue, 27 Feb 2007 13:25:04 +0100

Hi David, On Friday, 2007-02-23 18:22:15 -0500, David A. Wheeler wrote: > I said: > > > > > WEEKNUM(x;0) == WEEKNUM(x; WEEKDAY(DATE(1;1;YEAR(x))) > > Eike: > > They are dfferent simply because WEEKDAY(DATE(YEAR(x);1;1)) returns > > a number between 1 and 7. > > Well, sure, but the ANSWER should ALWAYS be the same. By definition. WEEKDAY(DATE(YEAR(x);1;1)) computes the day of the week on January 1 of the given year. If its result is sent in as the second parameter, the result should be the same as if I'd used "0" for the day. Ah, sure, yes, I was blind. Eike -- Automatic string conversions considered dangerous. They are the GOTO statements of spreadsheets. --Robert Weir on the OpenDocument formula subcommittee's list.

**References**:**WEEKNUM reference***From:*Eike Rathke <erack@sun.com>

**Re: [office-formula] WEEKNUM reference***From:*"David A. Wheeler" <dwheeler@dwheeler.com>

**Re: [office-formula] WEEKNUM reference***From:*Eike Rathke <erack@sun.com>

**Re: [office-formula] WEEKNUM reference***From:*"David A. Wheeler" <dwheeler@dwheeler.com>

**Re: [office-formula] WEEKNUM reference***From:*Eike Rathke <erack@sun.com>

**Re: [office-formula] WEEKNUM reference***From:*"David A. Wheeler" <dwheeler@dwheeler.com>

**Re: [office-formula] WEEKNUM reference***From:*Eike Rathke <erack@sun.com>

**Re: [office-formula] WEEKNUM reference***From:*"David A. Wheeler" <dwheeler@dwheeler.com>

**Re: [office-formula] WEEKNUM reference***From:*Eike Rathke <erack@sun.com>

**Re: [office-formula] WEEKNUM reference***From:*"David A. Wheeler" <dwheeler@dwheeler.com>

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]