The example here will suit your requirement:

http://www.bygsoftware.com/Excel/fun.../iso_dates.htm

--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"MickeW" wrote in message
...
I work in a Swedish environment, and would like to use the function
Weeknum,
the thing is, that Sweden uses a different way to number our weeks, for
example, the date 2005-01-01, is weeknumber 53, but if I use the function
Weeknum, it computes to weeknum 1. Is there anyone who has any suggestions
of
how to tackle that problem?

MickeW