Words and dates...
 

Someone very helpful helped me with a formula and hope maybe they can help me
once agian.

they gave me the following formula, which searched for text within a column.
What do I need to do to adjust that to choose specific text within certain
dates...

=COUNTIF(C:C,"RXL")

it works great... but I came up with the problem of needing only the Rxl's
between certain dates. This formula calculates them all.

Words and dates...
 

Let's assume that the dates are in column B. Try this:

=SUMPRODUCT(--(B1:B100DATE(2007,1,1)),--(B1:B100<DATE(2008,1,1)),--(ISNUMBER(SEARCH("RXL",C1:C100))))

This will give youdates between 1/1/2007 and 1/1/2008 that contain RXL in
column C.
--
HTH,
Barb Reinhardt



"m4d Ir15h" wrote:

Someone very helpful helped me with a formula and hope maybe they can help me
once agian.

they gave me the following formula, which searched for text within a column.
What do I need to do to adjust that to choose specific text within certain
dates...

=COUNTIF(C:C,"RXL")

it works great... but I came up with the problem of needing only the Rxl's
between certain dates. This formula calculates them all.