Jaybee

Right-click on you date header and select group and show detailgroup...

In the dialog, set the date range you want and select days and type 1 in the
'number of days' box

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"JayBee" wrote in message
...
I am using windows XP with Excel 2000, and I want my pivottable to display
sums of $ amounts for certain date ranges. Worksheet is formatted as
Column
"G" is dollar amounts, and Column "I" is dates (formatted xx/xx/xx). For
example, I want a total sales amount for posting dates between
3/03/03-04/04/04. I realize I can use dropdowns on the pivottable and
uncheck each unwanted date, but is there a calculated field I can create
to
do this automatically. (I tried IF & SUMIF, with 'xx/xx/xx<(name of column
I)<xx/xx/xx', but maybe I'm formatting incorrectly.) Thanks for any help!