I am trying to create/use a formula to count the date range between a
specific period in one column and whether another column contains the
specific test i.e...ICO or WFO I am getting a count back of 1 but it should
be 3 and I have double checked for unkown character spaces in the cells.
=COUNTA((E3:E58="2/1/2009")*AND(H3:H58="ICO"))

Can someone please help me with this problem????

"Ardy" wrote:

Hello All:
I have this formula =IF(AH2AQ2,"Y",IF(AH2<AQ2,"N",IF
(AH2="ND","N","N")))
it works pritty good with the exception of the ND part. when I test
it I expect to get a N when entering ND in AH2 but get Y. Can any
body show me where I went wrong.

Ardy