Weeks in Excel 2000
 

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.

thanks,
gt

Hi Glenys

See
http://www.rondebruin.nl/weeknumber.htm

Read Chip's site about week numbers (link on my page)




--
Regards Ron de Bruin
http://www.rondebruin.nl



"Glenys T" <Glenys wrote in message ...
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.

thanks,
gt

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.