Maybe something like this............

=SUMIF(A:A,"="&TODAY()-7,B:B)-SUMIF(A:A,""&TODAY(),B:B)

Vaya con Dios,
Chuck, CABGx3



"ashley0578" wrote:


Hi Chuck, I've seen that code you've posted in another post and I didn't
really want to actually type the dates in. I'm looking for something
else similar to what I would use in Access like date()-30 or date()-7.
Know what I mean??


--
ashley0578
------------------------------------------------------------------------
ashley0578's Profile: http://www.excelforum.com/member.php...o&userid=32757
View this thread: http://www.excelforum.com/showthread...hreadid=526119