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

On Oct 1, 4:49*pm, Daren wrote:
Thanks.



"Pete_UK" wrote:
Try this:

=OR(A1B1,B1C1,C1D1)

Hope this helps.

Pete

On Oct 1, 3:42 pm, 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.- Hide quoted text -

- Show quoted text -