Hello all,

I am trying to search through dates that I have in an Excel document to find any dates that do not continue or break the date order. What is the best way to do this?

Here is an example:

Good: the example below is good because the date continues from 22 to 23 march

Cell 1: 22 March 2009
Cell 2: 23 March 2009


Bad: the example below is bad because cell 2 date does not continue the date from cell 1

Cell 1: 22 March 2009
Cell 2: 24 March 2009

Sorry, forgot to add that I will be using a conditional format to highlight the mismatched dates
Hope that was explaned correctly! Thanks in advance for any help


Edited by: aburl81 on Mon Mar 23 13:02:45 EDT 2009.

Adan,

The "QUAD" (QUick And Dirty) way I would do this is to run an IF condition next to the date column - something like =IF(Date Diff("d", Cell1, Cell2)=1,"",***). That way, you can look down the column and see where the breaks are.

BTW - this is untested/off the top of my head.

HTH,

AvgJoe

Thanks, I will give it a shot

Provided A1 has a header and your data starts in A2:

Select A3:A<endofyourrange>

Format=>Conditional Format=> Formula Is:

=(A2+1)<>A3

Martin