Hi,
I'm having some difficulty with excel 2007. My problem is that I have a list of dates (e.g., 5/12/2010 - 7/28/2010) in a pivot table and I want to create a logical function to filter these dates i.e., I want the function to filter the list to display dates that are 3, 7, 14, and 30 days prior to the current date.
Any help would be appreciated.