View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
John John is offline
external usenet poster
 
Posts: 2,069
Default Grouping by month in a Pivot Table

Grouping by month in a Pivot Table

I am aware of the grouping by month feature in a Pivot Table. However, I
would like to be able to group data by our accounting months, which end on a
Friday, not the last day of a month. Is there a way of defining months that
match our Accounts calendar ?

TIA
John.

--
John Reynolds