View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike Rogers Mike Rogers is offline
external usenet poster
 
Posts: 194
Default How to display date as week number

Steen

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

and http://www.rondebruin.nl/isodate.htm

HTH

Mike Rogers

"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.