Detecting missing dates....

  • Thread starter Thread starter xDeniumx
  • Start date Start date
X

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)
 
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
 
Back
Top