Wrong weeknumber 2004 / 2005

[Cris van Eijk]

Why this:?
Date Weeknumber
28-12-2004 53
29-12-2004 53
30-12-2004 53
31-12-2004 53
01-01-2005 1
02-01-2005 1
03-01-2005 2
04-01-2005 2


Here in the Netherlands week 01 of 2005 is from 03-01-2005 to 09-01-2005
Is there a patch for this problem?

regards,

Cris van Eijk

 

[Niek Otten]

Hi Cris,

See

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

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Niek Otten]

Hi Cris,

See

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

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Cris van Eijk]

Hi Niek,

Thanks for the info, but the Excel-issue was just for reference.
The error occurred in our CRM-application SalesLogix. (Non Microsoft)

I assume slx uses the same reference as Excel does: somewhere in the
Windows-registry or something?
Note: Outlook2003 on the same machine shows the right numbers. What's the
difference?

Regards,

Cris van Eijk

 

[Niek Otten]

Hi Cris,

AFAIK the weeknumbers are not stored, but are derived from dates thru
formulas.
But there are different weekumber systems. Apparently your Outlook (maybe
Dutch version?) uses ISO weeknumbers and the other applications don't. Chips
article tells you how to get it in Excel, you'll probably have to ask the
supplier of SalesLLogix to allow for different weeknumber systems.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel