"Fred Smith" wrote:

What do you consider to be the average?

Is it the (Max - Min) / 2
Is it the sum of the differences divided by the count?
Is it something else?

I don't see how you get 2 months and 3 days with the data you provided.

Regards,
Fred.

"Jman" wrote in message
...
A1:A200
01/07/08
07/07/07
04/23/07
11/30/06


C1: I need average days between dates, considering leap years.

And is it possible to format C1 to equal.."2 month 3 days"
Thanks.



My bad, i didnt explain myself enough, the "2 "months and "3" day is just an example how i want the cell to be formated.
=DATEDIF(A4,G2,"m")&"m "&DATEDIF(A4,G2,"md")&"d"

I used this formula and it gave me.. cell format example. (""m ""d)