What error are you getting with Pivot Tables?
Make sure there are no blank cells in your "dates" columns, then you
should be able to group dates by weeks, months, or years.
Is your "date" recognized as a date or is it "text"?


--
Ron H
------------------------------------------------------------------------
Ron H's Profile: http://www.excelforum.com/member.php...fo&userid=9749
View this thread: http://www.excelforum.com/showthread...hreadid=391624