Are you sure about "So the first Monday of the year is the start of week 01.
(week number)"?

I thought that week 01 was any one of the following equaivalent
descriptions:
a.. the week with the year's first Thursday in it (the formal ISO
definition),
b.. the week with 4 January in it,
c.. the first week with the majority (four or more) of its days in the
starting year, and
d.. the week starting with the Monday in the period 29 December - 4
January.
From those definitions, the first Monday of the year is not necessarily in
week 01.
--
David Biddulph

"jaf" wrote in message
...
Hi Peter,
What function are you using?

You don't appear to be using the correct date format. That may be why
you're running into problems.

The ISO standard is not dd-mm-yy, it's yyyy-mm-dd.

From ISO 8601...
5.2.1.1 Complete representation
When the application identifies the need for an expression only of a
calendar date, then the complete representation
shall be a single numeric data element comprising eight digits, where
[YYYY] represents a calendar year, [MM] the
ordinal number of a calendar month within the calendar year, and [DD] the
ordinal number of a day within the calendar
month.
Basic format: YYYYMMDD EXAMPLE 19850412
Extended format: YYYY-MM-DD EXAMPLE 1985-04-12

And...
day of the week is represented by one decimal digit. Monday shall be
identified as day [1] of any calendar
week, and subsequent days of the same week shall be numbered in ascending
sequence to Sunday (day [7]).

calendar week is represented by two decimal digits. The first calendar
week of a year shall be identified as
[01] and subsequent weeks shall be numbered in ascending sequence.

So the first Monday of the year is the start of week 01. (week number)


John



"Peter" wrote in message
...
Greetings all,

Us date format: 01/10/2009 ( January 10th 2009) 1. I want it to convert
to ISO 8601 standard: dd-mm-yy
2. I want the day number (Sunday Day 1)..

I am trying all kind formats..customs..regional settings...but it gives
me wrong results..so fora example...01 June 2009...returns Saturday...

Thanks!