[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: Re: [office-formula] WEEKNUM reference
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. --- David A. Wheeler
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]