Do the following:
I entered your sample data in columns A to C, and rows 1 to 4.
Enter todays date in cell G1.
In column D, next to the values in coulumns A, B, & C, enter the
following formula:
=$G$1-B1
and drag down for all the rows in column A. This is the number of days
from the invoice date.

Enter the following figures in cells A118 to D118:
31, 61, 91, 121
And in A119 to D119
60, 90, 120, (last cell should be blank)

in row 120 cell A120 enter formula:
=A118&" - " &A119
and drag to your right till column D

In row 121, cell A121 enter formula:
=SUMPRODUCT($C$1:$C$4,--($D$1:$D$4=A118),--($D$1:$D$4<=A119))
and dragto copy to your right till D121

That should give you the required result

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=373548