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
Bookmarks