Is there a way to get an AVG date?
 

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

Is there a way to get an AVG date?
 

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!

Is there a way to get an AVG date?
 

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!

Is there a way to get an AVG date?
 

thanks to both of you!



"mikeb" wrote:

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