There was a link to this a few days back.

Week number is defined in some special ISO standard

Steve

On Sun, 19 Nov 2006 08:07:01 -0000, OC
wrote:

You could always use a formula like this with your date in A1.

=ROUNDUP((A1-DATE(YEAR(A1),1,0))/7,0)

Hope it helps...


"Steen" wrote:

Hi

Is is possible to display a date (2006.11.19) as week number (47)?

I have tried to find a usefull format in format cells..., but it seems
that
is not possible - no "ww" in there...

Any help would be appriciated.