Daily Pivot Filter based on Date range specified in cells

I am trying to have the vba update the filters of a pivot table to a specified date range (Start = F1 End = H1)

Currently I can do it with manual dates, but not dates from a cell

Please Login or Register  to view this content.

One issue is that it is possible one of the dates in the range is non exhistent (ex 9/01/2012-09/10/2012 filter range but there may be no data for 9/10/2012)


Basically I am looking for something that would do this:

Please Login or Register  to view this content.

Any help would be greatly appreciated