Change column A to a custom format (CellsFormatCustom) of "From "
dd.mm.yy, including the quotes, and filter column A

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Rao Ratan Singh" wrote in message
...
Hi all,
I m using this formula ="From "&TEXT(MIN(A6:A2151),"dd.mm.yy")&" to
"&TEXT(MAX(A6:A2151),"dd.mm.yy") for Data entered from a Date to last
date.
But when I autofilter by Date this formula does not change according to
Date.

How i should modify this formula so it can be change according to filtered
range.

Regards

RRS