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.

=TEXT(MIN(C:C),"mm/dd/yy")&"-"&TEXT( MAX(C:C),"mm/dd/yy")
--
Don Guillett
SalesAid Software
(E-Mail Removed)
"J.W. Aldridge" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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.
>

=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


On 13 Nov 2006 13:44:04 -0800, "J.W. Aldridge" <(E-Mail Removed)>
wrote:

>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.