OR
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.
|