If you want it numeric

=--(YEAR(A2)&TEXT(WEEKNUM(A2),"00"))

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


"Ron de Bruin" wrote in message ...
You can use this

=YEAR(A2)&TEXT(WEEKNUM(A2),"00")

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


"RonB" wrote in message ...
I use YEAR(cell)&WEEKNUM(cell) to organize data in time buckets. This returns
yyyyw numbers for weeks 1 through 9, which when put in a pivot table or
sorted does not sort in a correct date order. Is there a way to force WEEKNUM
toreturn 01 - 09 for weeks 1 thorugh 9 of a given year?
--
RonB