Detecting missing dates....

[xDeniumx]

=IF((A2-A1)>1,"Missed " & TEXT(A1+1,"mm/dd/yy") & IF((A2-A1)>2," - " &
TEXT(A2-1,"mm/dd/yy"),""),"")


I tried that, but it didn't work... ...If you have tried and tested
this formula, could you please email me a have a sample book? Thx





(e-mail address removed)

 

[Max]

Think JE's solution works fine ..

Just ensure that your sample data is split*
so that only *dates* are in col A

As outlined in your other post, to split:
use Data > Text to columns on the col with "Date - Time"

In the wizard:
Step1: Select "Delimited" > Next
Step2: Check "space" > Next

Step3:
In the data preview pane: click to select the dates col
Under "Col data format": Select "MDY" from the drop menu

Click Finish