Currently I have an excel file that has some basic trading data (open, high, low, close, date) and some values to help sort through the data (day type, direction, gap etc.) i've created a pivot table and I can filter for various parameters wonderfully.

When I filter for different criteria I end up with a list of dates and values. What I would like to be able to do is to take this list of dates and generate a table of data for either the day prior or the day after the one listed initially (no new calculations). Is there a simple way to do this? Ideally I would like the new list to also be a pivot table but it isn't essential. Ordinarily I would post a sample file but I prefer to keep this one close to the vest.