I have a series of projects, each w/ 10 dates. I am trying to count the
number of projects that have a least one date that was in 2006 or 2007 and
return a Value of "Yes"

I am thinking this is a whopper of an IF statement where for every date I
have to check it against 2006 or 2007, but can't pull it together in my head
and was hoping there was a simpler way.

Thanks.

Say there is a row for each project with the project name in column A and the
dates in cols B thru K. Put the following formula in column L:

=if(sumproduct(--(year(b1:k1)=2007))+sumproduct(--(year(b1:k1)=2006))0,"yes","")

and copy down. There will be a "yes" for every row with at least 1 date in
2007 or 2007
--
Gary''s Student - gsnu200777


"PAL" wrote:

I have a series of projects, each w/ 10 dates. I am trying to count the
number of projects that have a least one date that was in 2006 or 2007 and
return a Value of "Yes"

I am thinking this is a whopper of an IF statement where for every date I
have to check it against 2006 or 2007, but can't pull it together in my head
and was hoping there was a simpler way.

Thanks.