Date Sequence 2

[Daren]

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.

 

[Pete_UK]

Try this:

=OR(A1>B1,B1>C1,C1>D1)

Hope this helps.

Pete

 

[Dave]

Hi,
If your 4 dates are in A1:A4, then try the following in another cell:
=AND(A4>A3,A3>A2,A2>A1)
Regards - Dave.

 

[Teethless mama]

Try this:

=SUMPRODUCT(--(B11>A1:C1))=3

 

[Daren]

Thanks.

 

[Daren]

Thanks.

Try this:

=SUMPRODUCT(--(B11>A1:C1))=3

 

[Daren]

Thanks.

Try this:

=OR(A1>B1,B1>C1,C1>D1)

Hope this helps.

Pete

 

[Pete_UK]

You're welcome.

You didn't make it clear what the TRUE represented - in my formula it
would be true for any date out of sequence.

Pete