You may want to INT it

=INT(AVERAGE(rng))

--
HTH

Bob Phillips

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

"Jim Thomlinson" wrote in message
...
You can just use the average function. Dates are ultimately just stored as
long integers so the average works just fine...
--
HTH...

Jim Thomlinson


"mikeb" wrote:

Is there a way to calculate the average date for a # of dates? thanks!