Time Difference

Again tring to eliminate multiple formulas...

Rep E-Date P-Date
Eddie 4/1/08 4/25/08
Eddie 4/2/08 4/13/08


I am looking to get the diffence in days between the two dates and get an average of that difference.

Right now i have a seperate function =datedif(x,x,"d"), then a seperate funtion {=average(if(x="Eddie",if(x=3,x)))}

Any help appreciated

This combines them into one formula: =SUMPRODUCT(--(A1:A2="Eddie"),C1:C2-B1:B2)/COUNTIF(A1:A2,"Eddie")

You don't really need DATEDIF if you want a difference in days, just subtract one date from the other, e.g.

=C2-B2

so for an average date difference when column A is Eddie,

=AVERAGE(IF(A2:A10="Eddie",C2:C10-B2:B10))

confirmed with CTRL+SHIFT+ENTER

worked perfectly