I have a Project Advance woksheet. The purspose of the workshhet is to track
all advances that are given to the cash custodians in the field. All advances
are assigned an advance number and any settlement received against the
advance must refer to the advance number.

Every month, advances are analysed according to the days outstanding i.e
0-30 days, 31-60 and 61-90 and 90 and over. Advances are not fully settled
all the time and there can be some left over funds from previous advances.

I need a formula that will achieve this task.

1) The formula should calculate the no of days outstanding by comparing the
date that advance was first issued with today() function.

2) It should sum total amount outstanding against a particular advance
number and show the no. of days outstanding in the corresponding column.


Thank you in advance for your help
Rushdhi