I wonder if anyone could help me?
In my excel file I have two workbooks. One workbook with data (production
schedule) and in the other workbook I have a pivot table to list jobs
delivered by customer name. What I would like to do is to report the data
between two date ranges in the pivot table. At this moment in time I only
have the option to choose a specific date or all.
Thanks
Matt Elms

One way to do this is to drag the Date field to the Row area.
Right-click on the Date field button, and choose
Group and Show Detail Group
Enter a Start and End date, and click OK
From the Date field dropdown list, remove the check mark for
the first item, which should be <[your start date]
Drag the Date field back to the Page area.

Matt Elms wrote:
I wonder if anyone could help me?
In my excel file I have two workbooks. One workbook with data (production
schedule) and in the other workbook I have a pivot table to list jobs
delivered by customer name. What I would like to do is to report the data
between two date ranges in the pivot table. At this moment in time I only
have the option to choose a specific date or all.

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html