Hi

I use this formula (with date in cell G2, and NB! I left delimiters as I use
them - when they aren't passing, then edit the formula):

=IF(INT((G2 -
DATE(YEAR(G2);1;1)+1+7-WEEKDAY(G2;2)+4)/7)=0;INT(((DATE(YEAR(G2)-1;12;31)-DA
TE(YEAR(G2)-1;1;1)+1)+7-WEEKDAY(DATE(YEAR(G2)-1;12;31);2)+4)/7);IF(AND(INT((
G2-DATE(YEAR(G2);1;1)+1+7-WEEKDAY(G2;2)+4)/7)=53;WEEKDAY(DATE(YEAR(G2);12;31
);2)<4);1;INT((G2-DATE(YEAR(G2);1;1) +1+7-WEEKDAY(G2;2)+4)/7)))


Arvi Laanemets


"soren" wrote in message
...
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?