Try this:

=SUMPRODUCT(--(B1:D1A1:C1))=3



"Daren" wrote:

I have a spreadsheet with four dates of columns. These dates are supposed to
occur in order, e.g. 4/1/08, 5/2/08, 6/2/08, and 7/2/08. While this is not a
validation question, I need to know if there's a formula to use that can look
at those four cells in the respective four columns and return a TRUE or FALSE.

Thanks.