When you apply data|Filter|autofilter, you can use =subtotal(5,...) to get the
minimum and =subtotal(4,...) to get the max.

=Min() and =max() will not ignore those hidden rows.

so:
="From "&TEXT(subtotal(5,A6:A2151),"dd.mm.yy")
&" to "&TEXT(subtotal(4,A6:A2151),"dd.mm.yy")

May work for you

Rao Ratan Singh wrote:

I m using this formula/format to displya Date Range what i select by autofilter
"From "&TEXT(MIN(A6:A2151),"dd.mm.yy")&" to "&TEXT(MAX(A6:A2151),"dd.mm.yy")

This formula/format in normal position it works correctly but when i filter
by drop down list by selecting any date this not work properly. what should
make change in this.

--

Dave Peterson