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.

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.

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

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.

Thanks.

"Dave" wrote:

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

Thanks.

"Teethless mama" wrote:

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.

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.

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 -