Jjuan,

You could do it with a helper column. Let's say your dates are in column A.
In another column, Let's say B, put =DATE(YEAR(A2),MONTH(A2),1). This will
give the date as the first of the month, regardless of day of month. Format
it something like mm-yy. You can hide it if you want to . Use that column
in your grouping in the pivot table (drag it to the left or top).
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"jjuan" wrote in message
...
I have a list of dates from 1/1/2000 to 1/1/2007 and i want to get the sum
of it monthly.i want to get the sum of 2/1/2006 to 2/28/2006.
can you give me some tips?
thanks!