WEEKNUM

[Guest]

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?

 

[Ron de Bruin]

You can use this

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

 

[Ron de Bruin]

If you want it numeric

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

 

[Guest]

Worked great! Thanks....
--
RonB

If you want it numeric

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