I'm comfused??? how to apply this
here is an example of what I'm trying to do
TODAY 2/16/2006
INV 1 10/01/05 $100
INV 2 10/18/05 $100
INV 3 11/01/05 $100
INV 4 12/30/05 $100
INV 5 01/30/06 $100
total $500
total over 30 days $400
total over 60 days $300
total over 90 days $200
total over 120 days $100

I don't know how to apply the formular to the cells
Thanks so much

"SteveG" wrote:


Try this.

=SUMPRODUCT(--(DATEDIF(B2:B5,TODAY(),"d")+1=120))

B2:B5 are your dates. DATEDIF counts the days between the date in your
dates and TODAY. Add the 1 to include the start date.

Does that help?

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=513244