It makes sense to me. For more information, see:

http://www.cpearson.com/excel/WeekNumbers.aspx
--
Gary''s Student - gsnu201001


"The Fool on the Hill" wrote:

Hello Gary's Student,

The first three days of the year where fri 1st of jan till Sat 3 januari.
According to the european standard, this means that week 1 is actually 2.
Hence adding -1 in the formula makes sense (here in europe) ?

Thanks 4 your answer.

Kind regards,

Jan-Willem

"Gary''s Student" wrote:

The WEEKNUM function considers the week containing January 1 to be the first
week of the year. However, there is a European standard that defines the
first week as the one with the majority of days (four or more) falling in the
new year. This means that for years in which there are three days or less in
the first week of January, the WEEKNUM function returns week numbers that are
incorrect according to the European standard.

--
Gary''s Student - gsnu201001


"The Fool on the Hill" wrote:

Hello Excel-lent users,

I use Weeknum(today()) to determine which weeknumber is valid for today. The
problem is that for today 11 feb 2010 (02/11/2010 in us date config) it
returns with weeknumber 7 instead of week number 6. The same is applicable if
I use
weeknum(A1) (where A1 eq today()) as well as weeknum(A1;1) and weeknum(A1;2).

Can I rely on using weeknum(today())-1 or should I do something else?

Please help !