Thread: How to extract the month in a Pivot Table
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mark Mark is offline
external usenet poster
  
Posts: 989
Default How to extract the month in a Pivot Table
I have a date in excel "Period_End_Date", this date is for employee hours
worked. I create a pivot table to extract data by date & individula, then
summarize this and I need to, using the GETPIVOTTABLEDATA to get this
information into another worksheet. How do I summarize the months data?
Reply With QuoteReply With Quote