Date Filter issue

  • Thread starter Thread starter Sri Harsha
  • Start date Start date
S

Sri Harsha

I have a pivot table which has Report Filter as date. I want to have a week
view (like Wk1, WK2 etc) in the filter. Is it possible? if yes, how?
 
In xl2003, you can group by dates by years, months, quarters, but not weeks.

I'd use a helper column and use a formula that returns the week number based on
the date field.

You may want to read Ron de Bruin's site for more week number info:
http://www.rondebruin.nl/weeknumber.htm
 
Back
Top