Roger / Bob,

Thankyou for your assistance, I am a long way closer to were I want to be.

Rogier,

I have 1 question about you solution. Everything appears to work perfectly
apart from 1 bit. Were the Start and End dates are the same, the value is 0.
The formula doesnt appear to account for this and I dont seem to be able to
adapt it to do so. So it break the numbers down from 1 - 5 days, 6 - 10 days
and so on ok, but it wont allow for the open and close to be the same day.

Rgds Paul

"Roger Govier" wrote:

Hi

On the same sheet, in cell F1 enter 5, G1 10, H1 20 and in I1 100 (or a
large number of days that will not be exceeded)
In E2 enter Accepted, and in E3 enter Rejected
en cell F2 enter
=SUMPRODUCT(($B$2:$B$6<"")*
($B$2:$B$6-$A$2:$A$6E$1)*
($B$2:$B$6-$A$2:$A$6<=F$1)*
($C$2:$C$6=$E2))

and copy across through cells G2:I2
Copy F2:I2 down to F3

--
Regards

Roger Govier


"phocused" wrote in message
...
Hi,

I have a list of Start Dates starting in A2 and running down to A35. I
also
have a list of End Date strting in B2 and running down to B35 (Note:
Not all
start dates will have a corresponding end date)
Listed in C2 is a status, Approved, Rejected etc

Problem
I am trying to calculate the number of days between the start and end
date
and list it as the number approved, rejected in 5 days or less : 6 to
10 days
: 10 to 20 days or greater than 20Days
I also want to break this down by month

So i would end up with a result looking like

Stats for December
number of calls closed in <= 5 days 6 - 10 days 10 -
20
days 20@
Approved 3 2
10 0
Rejected 1 0
0 0

I can do this over several calculations using several worksheets, but
i
would like to do it in a single sheet using an array

Is this possible ?

Rgds Paul