Have a look at my date format udf http://www.kixtart.org/ubbthreads/showflat.php?Cat=0&Number=83494&an=&page=0&vc=1

It returns a load of different values, including week number.

NB "week number" is one of the elements that requires the SerialDate() UDF for calculations.