Thread: Convert date field to month in Pivot table
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MESTRELLA29 MESTRELLA29 is offline
external usenet poster
  
Posts: 26
Default Convert date field to month in Pivot table
I have a Table wich has date fileds,
Date Order No. Qty Shipped
01-27-07
03-19-07
03-20-07

How do I go about to create a pivot table that groups this by month on the
Page Filed of the pivot table.
Reply With QuoteReply With Quote