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.