Thanks Frank

My Ctrl-C is not working very good anymore
I will purchase a new keyboard soon

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



"Frank Kabel" wrote in message
...
Hi Ron
I think for the first one you meant:
http://www.cpearson.com/excel/weeknum.htm

:-))

--
Regards
Frank Kabel
Frankfurt, Germany
"Ron de Bruin" schrieb im Newsbeitrag
...
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.