how to sort between 2 date

L

lalaexcel

Hi there

Please tell me how to data sorted between 2 date by advanced filter. I
can only have data larger or smaller than a date but I can't make data
in between two date.

regards
lalaexcel
 
B

Bob Phillips

Create a helper column that tests the date to be between the ranges

=AND(C2>=datevalue1,C2<=datevalue2)

and sort by that column

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
L

lalaexcel

Hello Bob

Thank you for your help.

Would you please further explain how. I finished typing th
"=and(c2>....." then I got a "False" in the cell but nothing more.

Regards
lalaexce
 
B

Bob Phillips

What I was suggesting is add a column, and in D1 add Test, D2, add the
formula =AND(C2>=--"2006-04-02",C2<=--"2006-04-04") and copy down (change
the dates to suit). This will only give TRUE or False but then create a
criteria range of Test, and TRUE, and use both columns and the criteria
range in the filter.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
L

lalaexcel

Hi Ardus

I was too early to be happy. For the problem seemed to be settled onc
but could not be seen again. I tested the ">=date<=date..." method an
succeeded once. Then I deleted the worksheet and tried again with th
one that I had genuine data but the problem appeared again. I checke
carefully of the wording but I just couldn't repeat once again with th
desired outcome. I could have only the heading of the range where
wanted to advanced filter but nothing more. Please help

regards
lalaexce
 
B

Bob Phillips

Can you give an example of your data, the dates, the columns, headings and
the criteria and step by step what you did?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
L

lalaexcel

Hi Bob

I had a column (say a) for the date and a column (say b) for the qty.
I was trying to have a column (say d) and a column (say e) for putting
in criteria. I could have date sorted either by earlier or later than
a specific date. I could not get data of a period between two dates.
You advised me to have >=date1<=date2 worked once a while but not after
I re-tested it with a new file. If I set the criteria as just
mentioned, I would only get the heading of date,qty but nothing else.
The sorting stopped.

Regards
lalaexcel
 
Top