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

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

Sir,
Do you mean should I put this formula in cutom format of cell selecting A
column?



"Bob Phillips" wrote:

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

It's not a formula, it's a format. And yes, he means enter it as a custom
format.

--
Regards,
Fred


"Rao Ratan Singh" wrote in message
...
Sir,
Do you mean should I put this formula in cutom format of cell selecting A
column?



"Bob Phillips" wrote:

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

Hi Smit,
Probably my question was understood wrongly. My this Formula/format "From
"&TEXT(MIN(A6:A2151),"dd.mm.yy")&" to "&TEXT(MAX(A6:A2151),"dd.mm.yy") is in
cell E1 and Date Range is in A Column from A6.

Whe I use Custom AutoFilter to Date Column. This A6 Formula Should change
according to Filter.

Assume that I filter for the Month of March Month.
CustomAutoFilterIsGreaterThanAndIsLessThan This Formula should display
"From 01.03.07 to 31.03.07

So please tell me what is necessary changes should I do in this
formula/format.

Regards

Rao Ratan Singh

"Fred Smith" wrote:

It's not a formula, it's a format. And yes, he means enter it as a custom
format.

--
Regards,
Fred


"Rao Ratan Singh" wrote in message
...
Sir,
Do you mean should I put this formula in cutom format of cell selecting A
column?



"Bob Phillips" wrote:

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

You're right, we misunderstood your requirements.

The formula doesn't change because it's still looking at the entire range
(A6:A2151). Filtering doesn't change a formula, it only chooses rows to display.

However, you can switch to the Subtotal function, because it will recognize on a
filtered group.

"From "&TEXT(Subtotal(4,A6:A2151),"dd.mm.yy")&" to
"&TEXT(Subtotal(4,A6:A2151),"dd.mm.yy")

should do what you want.
--
Regards,
Fred


"Rao Ratan Singh" wrote in message
...
Hi Smit,
Probably my question was understood wrongly. My this Formula/format "From
"&TEXT(MIN(A6:A2151),"dd.mm.yy")&" to "&TEXT(MAX(A6:A2151),"dd.mm.yy") is in
cell E1 and Date Range is in A Column from A6.

Whe I use Custom AutoFilter to Date Column. This A6 Formula Should change
according to Filter.

Assume that I filter for the Month of March Month.
CustomAutoFilterIsGreaterThanAndIsLessThan This Formula should display
"From 01.03.07 to 31.03.07

So please tell me what is necessary changes should I do in this
formula/format.

Regards

Rao Ratan Singh

"Fred Smith" wrote:

It's not a formula, it's a format. And yes, he means enter it as a custom
format.

--
Regards,
Fred


"Rao Ratan Singh" wrote in message
...
Sir,
Do you mean should I put this formula in cutom format of cell selecting A
column?



"Bob Phillips" wrote:

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