View Single Post
  #2   Report Post  
Ron de Bruin
 
Posts: n/a
Default

Hi jPeich

See Chip Pearson's site
http://www.rondebruin.nl/weeknumber.htm

And also this week calendar file
http://www.rondebruin.nl/weeknumber.htm



Regards Ron de Bruin
http://www.rondebruin.nl



"jPeich" wrote in message
...
I need to get the week number in excell from a cell with a date
(dd/mm/aaaa),
but the first week of the year has 3 possiblilities, first week, with day
nš 1, first week with at least 4 days of the new year or finally the
first
full week.

How to do this in excell ? I tried with weeknum() but I can't choose the
first week

Thanks.