date range in one cell

[J.W. Aldridge]

I have a list of dates in one column. In one cell, i need to know the
range.

I tried getting the min value in one cell , then the max in another,
then i combined the two using CONCATENATE however, that only returns
the value (3901739023).

Any suggestions to show the min (earliest date) and max (latest date)
in the same cell?

" 10/27/06 - 11/02/06 "

"date dash date"


Thanx.

 

[Don Guillett]

=TEXT(MIN(C:C),"mm/dd/yy")&"-"&TEXT( MAX(C:C),"mm/dd/yy")

 

[Gord Dibben]

=TEXT(A1,"mm/dd/yy")&" - "&TEXT(A2,"mm/dd/yy")

Assuming min and max dates are in A1 and A2


Gord Dibben MS Excel MVP