Thread: Date Sequence 2
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Daren Daren is offline
external usenet poster
 
Posts: 162
Default Date Sequence 2

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.