=SUMIF(A1:A9,"<="&DATE(2004,4,2),B1:B9)-SUMIF(A1:A9,"<"&DATE(2004,3,29),B1:B9)

Try something like the above.

A1:A9 would reference your dates to be summed.

B1:B9 references the column to be summed due to the specified date range.

Of course you would need to set your range in the identical format.

Hope this helps you out

--
Message posted via http://www.officekb.com