Take a look he

http://cpearson.com/excel/weeknum.htm


In article ,
"Glenys T" <Glenys wrote:

I work in weeks, and Excel is labeling week no. 1 as jan.1 in europe they
have week no. 1 as jan 3. how can I change excel to read week no.1 as jan 3.
I am having trouble with my reporting and manufacturing schedule since we
deal with european factories.