Date in Cell

You need to get a copy of Excel 2007 - the missing manual from O'REILLY available on line. It's not just called "the book that should have been in the box" for nothing. Even someone who has been using Excel for years can learn a thing or two.

try using IF > 0 for the cells =IF(a1>0,1) . SUMIF can be used to isolate ranges of dates. Try using the Fx right next to the formula entry box to get ideas on what functions best suit your needs. In-program help is available, although a little hard to understand at times. The dates in the cells are stored as numbers and can be manipulated mathematically.

Cell A1 1/8/13..... Cell B1=IF(A1>0,1)

Cell A2 2/8/13..... Cell B2=IF(A1>0,1)

Cell A3 no date.....Cell B3=IF(A1>0,1)

Cell A4 4/8/13..... Cell B4=IF(A1>0,1)

Cell A5 5/5 13..... Cell B5=IF(A1>0,1)

Cell B6 =IF(SUM(B1:B5)>4,True,False)