WEEKNUM

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
Back
Top