Pull data from pivot table based on date

[djdjdj]

Hi all,

I have a large pivot table with account info over several years, and would like to pull selected data from the pivot table to create some graphs.

I have the pivot table on Sheet 2, and a smaller table with only the selected data on Sheet 1. I would like to then create the graphs from the smaller table on Sheet 1.

My formula is =GETPIVOTDATA("Sales";Sheet2!$E$4;"Date";DATE(2011;1;1);"Account";1)

So basically what I want is the DATE() part of the above formula to be filled in based on the value of a cell in Sheet 1. Something like DATE(Sheet 1!B3). Any ideas?

Thanks!

Darrel