software

I have a column with dates and what I would like to do is in two different
cells is place two different dates and then have the dates be placed in a
different column in ascending order.

dates in column from date to date results
02/04/2005 12/01/2005 03/31/2006 01/05/2006
01/05/2006
02/13/2006
12/12/2005
04/12/2006
02/13/2006Hi Joe
Assuming your dates start in A2, your From date is in B1, your To date
is in C1.
You will need a helper column, D, which can be hidden if required.
In cell D2
=IF(AND(A2gt;=$B$1,A2lt;=$C$1),A2,quot;quot;) and copy down column D as far as
required.
In cell E2
=IF(ISERROR(SMALL($D:$D,ROW(1:1))),quot;quot;,SMALL($D:$D, ROW(1:1)))
again, copy down as far as required.
Incidentally, from your sample, I make the earliest qualifying date to
be 12/12/2005 not 01/05/2006

--
Regards

Roger Govierquot;Joe Leonquot; gt; wrote in message
...
gt;I have a column with dates and what I would like to do is in two
gt;different
gt; cells is place two different dates and then have the dates be placed
gt; in a
gt; different column in ascending order.
gt;
gt; dates in column from date to date
gt; results
gt; 02/04/2005 12/01/2005 03/31/2006 01/05/2006
gt; 01/05/2006
gt; 02/13/2006
gt; 12/12/2005
gt; 04/12/2006
gt; 02/13/2006
gt;
Roger,

Thanks! Works like a charm and very well explained....

Joe...

quot;Roger Govierquot; wrote:

gt; Hi Joe
gt; Assuming your dates start in A2, your From date is in B1, your To date
gt; is in C1.
gt; You will need a helper column, D, which can be hidden if required.
gt; In cell D2
gt; =IF(AND(A2gt;=$B$1,A2lt;=$C$1),A2,quot;quot;) and copy down column D as far as
gt; required.
gt; In cell E2
gt; =IF(ISERROR(SMALL($D:$D,ROW(1:1))),quot;quot;,SMALL($D:$D, ROW(1:1)))
gt; again, copy down as far as required.
gt; Incidentally, from your sample, I make the earliest qualifying date to
gt; be 12/12/2005 not 01/05/2006
gt;
gt; --
gt; Regards
gt;
gt; Roger Govier
gt;
gt;
gt; quot;Joe Leonquot; gt; wrote in message
gt; ...
gt; gt;I have a column with dates and what I would like to do is in two
gt; gt;different
gt; gt; cells is place two different dates and then have the dates be placed
gt; gt; in a
gt; gt; different column in ascending order.
gt; gt;
gt; gt; dates in column from date to date
gt; gt; results
gt; gt; 02/04/2005 12/01/2005 03/31/2006 01/05/2006
gt; gt; 01/05/2006
gt; gt; 02/13/2006
gt; gt; 12/12/2005
gt; gt; 04/12/2006
gt; gt; 02/13/2006
gt; gt;
gt;
gt;
gt;