you could put an extra column in your spreadsheet which tests the date
and returns "ignore" or "use"

then just put that criteria in the top left box in the pivot table
layout and set it to "use"

You will then only analyse the required data


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=528129