Thread: Date Sequence 2
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Date Sequence 2

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.