Hi
You could add an extra column to your source data, with a formula to set
True or false dependent upon whether the dates fall within the specified
range.
Then just filter the PT for True on that column.

--
Regards

Roger Govier


"Avi" wrote in message
oups.com...
I want to generate a Pivot table based on some filters. e.g. my data
contains project start and end dates in two columns. i have close to
100 projects in my data.

Now if I generate the pivot for whole data, I see all the projects. I
want to filter the projects for which either of start or end date is
between two given dates (user entered).

I had been breaking my head for long to acheive this.

Please help.

Thanks,