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 !