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