I figured it out, woohooo!

If I put -1 into cell e1 it performs the calculation on the dates that are
equal as well.

thanks

Rgds Paul

"Bob Phillips" wrote:

=SUMPRODUCT((B1:B10-A1:A10),--(C1:C10="Approved"))

etc.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"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