For ISO weeknbrs have a look he http://www.cpearson.com/excel/weeknum.htm
Cheers Michael

Ron Rosenfeld wrote:
On Fri, 20 Nov 2009 04:25:02 -0800, Derek M
wrote:

Duh, sussed it =WEEKNUM(A1)

Sorry for the wasted post :)

"Derek M" wrote:


OK, but keep in mind that Excel's weeknumbers are not computed the same as the
ISO standard. So be certain of what you want. If you require ISO weeknumbers,
post back for a UDF.
--ron