Wrong weeknumber 2004 / 2005

  • Thread starter Thread starter Cris van Eijk
  • Start date Start date
C

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
 
Hi Cris,

Pleas don't post to more than one group in separate posts.
See my last answer in other NG

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Wrong weeknumber 2004 / 2005 4
Week Number Format 4
macro help 1
Counting if Date1 is after and Date2 is before another date 5
LOOKUP function between two dates in Excel 2007 6
LOOKUP within a 1
DATE SORTING excel 2
DATE FORMULA 3

Back
Top