View Single Post
  #4   Report Post  
Harald Staff
 
Posts: n/a
Default

Hi Soren

See also
http://www.erlandsendata.no/english/...dateweeknumber
and
http://www.cpearson.com/excel/weeknum.htm

If you want to play with this yourself, one good approach is that January
4th is always in week 1.

HTH. Best wishes Harald

"soren" skrev i melding
...
I am working with week numbers and need Excel to accept as week 1 the

first
week of the year with 4 or more days. I.e. week starting Monday 3rd

January
2005 should be reflected as week 1.

The program reflects this week as week 2 by default. How to change this?