I have a pivot table and it has a filter which does filtering by month. I am trying to make sure that the filter is set depending upon the present month that can be looked up from another cell which uses the Today() function. Kindly let me know as to how I can assign the pivot table to filter based on a cell value.

Thanks,
Booo