Filter Pivot table between two dates

[Robertfu]

Hi Guys,

I have a time sheet table which has DATE, PROJ ID, CUST, HRS, WHO columns
I have a pivot table that uses the above table to summarise hours spent on projects. where
- PROJ ID & CUST are used for the row labels
- WHO is used for the column labels
- HRS is used for the SUM data.

I need to be able to filter the pivot table between two dates. The to/from dates can be in cells near the pivot table.
I do not mind using VBA
I do not want the dates to be displayed in the pivot table. I just need to summarise hours against projects between two dates.
I tried to use the DATE data in the Pivot table Report Filter, but that is painful to use.

Can anyone help me

Regards,

Robert