how to sort between 2 date

[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

[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)

"lalaexcel" <lalaexcel.26au3y_1145093400.4065@excelforum-nospam.com> wrote
in message news:lalaexcel.26au3y_1145093400.4065@excelforum-nospam.com...
>
> 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
>
>
> --
> lalaexcel
> ------------------------------------------------------------------------
> lalaexcel's Profile:
http://www.excelforum.com/member.php...o&userid=30585
> View this thread: http://www.excelforum.com/showthread...hreadid=533114
>

[Ardus Petus]

Define 2 criteria on the same field
date date
>=20/04/06 <=27/04/06


That should do it

HTH
--
AP

"lalaexcel" <lalaexcel.26au3y_1145093400.4065@excelforum-nospam.com> a écrit
dans le message de
news:lalaexcel.26au3y_1145093400.4065@excelforum-nospam.com...
>
> 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
>
>
> --
> lalaexcel
> ------------------------------------------------------------------------
> lalaexcel's Profile:
http://www.excelforum.com/member.php...o&userid=30585
> View this thread: http://www.excelforum.com/showthread...hreadid=533114
>

[lalaexcel]

Hello Bob

Thank you for your help.

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

Regards
lalaexcel

[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)

"lalaexcel" <lalaexcel.26aw6y_1145096100.5814@excelforum-nospam.com> wrote
in message news:lalaexcel.26aw6y_1145096100.5814@excelforum-nospam.com...
>
> Hello Bob
>
> Thank you for your help.
>
> Would you please further explain how. I finished typing the
> "=and(c2>....." then I got a "False" in the cell but nothing more.
>
> Regards
> lalaexcel
>
>
> --
> lalaexcel
> ------------------------------------------------------------------------
> lalaexcel's Profile:
http://www.excelforum.com/member.php...o&userid=30585
> View this thread: http://www.excelforum.com/showthread...hreadid=533114
>

[lalaexcel]

Hi Ardus

The case is solved. Thank you

[lalaexcel]

Hi Ardus

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

regards
lalaexcel

[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)

"lalaexcel" <lalaexcel.26e8sm_1145252400.5747@excelforum-nospam.com> wrote
in message news:lalaexcel.26e8sm_1145252400.5747@excelforum-nospam.com...
>
> Hi Ardus
>
> I was too early to be happy. For the problem seemed to be settled once
> but could not be seen again. I tested the ">=date<=date..." method and
> succeeded once. Then I deleted the worksheet and tried again with the
> one that I had genuine data but the problem appeared again. I checked
> carefully of the wording but I just couldn't repeat once again with the
> desired outcome. I could have only the heading of the range where I
> wanted to advanced filter but nothing more. Please help
>
> regards
> lalaexcel
>
>
> --
> lalaexcel
> ------------------------------------------------------------------------
> lalaexcel's Profile:
http://www.excelforum.com/member.php...o&userid=30585
> View this thread: http://www.excelforum.com/showthread...hreadid=533114
>

[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