Formula to find information between 2 dates

[Porous Metals Limited]

What formula can be used to select data between two dates (ie: 01Oct04 and
09Oct04), and if the information falls within that range, then post it to
another column, if not, then do nothing "0".

Thanks.

[Myrna Larson]

To copy the data from column B to column C, with the date in column A, put
this formula in C2 and copy down as far as needed:

=IF(AND(A2>=DATE(2004,10,1),A2<=DATE(2004,10,9)),A2,0)

It may be easier to put the starting and ending dates in two cells, e.g. C1
and D1. Then the formula is

=IF(AND(A2>=$C$1,A2<=$D$1),A2,0)


On Mon, 3 Jan 2005 08:33:04 -0800, Porous Metals Limited <Porous Metals
[email protected]> wrote:

>What formula can be used to select data between two dates (ie: 01Oct04 and
>09Oct04), and if the information falls within that range, then post it to
>another column, if not, then do nothing "0".
>
>Thanks.

[George Nicholson]

Assuming ColumnA = Date to evaluate and ColumnB = Information to be posted

In the "other" column:
=IF(AND(A2>DATEVALUE("10/1/2004"), A2< DATEVALUE("10/10/2004")),B2,0)

--
George Nicholson

Remove 'Junk' from return address.


"Porous Metals Limited" <Porous Metals [email protected]>
wrote in message news:[email protected]...
> What formula can be used to select data between two dates (ie: 01Oct04 and
> 09Oct04), and if the information falls within that range, then post it to
> another column, if not, then do nothing "0".
>
> Thanks.