Weeks in Excel 2000

[Guest]

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

 

[Ron de Bruin]

Hi Glenys

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

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

 

[JE McGimpsey]

Take a look here:

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