=CONCATENATE("Date Range": ",MIN([range])," - ",MAX([range]))

Note the space after the colon and before and after the hyphen,
elseeverythingwillgetsquashedtogetherlikethis.

Dave
--
Brevity is the soul of wit.


"Bdadmin" wrote:

I am attempting to put the range of MIN and MAX dates pulled from a column. I
would like it to look like:

Date Range: 9/6/2006 - 10/26/2006

from a column like this:

Date
09/06/2006
09/06/2006
09/10/2006
10/12/2006
10/26/2006

Thanks in advance
BD