Thread: OR
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PAL PAL is offline
external usenet poster
 
Posts: 200
Default OR

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.