How to capture date fields based on a condition

[kicassrt]

Hey guys

I have import data that will come in as dates. I am looking to get the dates noted in a column, or multiple columns if there are many breaks in the date. When I mean breaks I mean
in the example below the dates are consistent (B1 is 1 day earlier then A2) this continues until B3 and A4. I want to grab that period or in this example its 08/01/2011-08/30/2011 and note that in a column then continue on.. If there is no other breaks it will read 10/31/2011- whatever ending B column of data. These data columns won't be exactly the same on any given import into excel so they could have no breaks and be simply A1 - B40 or it could have a lot of breaks and I want to capture that in another worksheet with the breaks (followed by a simple math of the days total of that break period )... I think I need a Do Until loop but my mind is getting loopy trying to figure this out a I need to stop on a break (if there is one) get the data, then continue capturing any breaks until there is no data in column B
[TABLE="width: 500"]
<tbody>[TR]
[TD]Column A (start date)[/TD]
[TD]Column B (end date)[/TD]
[/TR]
[TR]
[TD]08/01/2011[/TD]
[TD]08/05/2011[/TD]
[/TR]
[TR]
[TD]08/06/2011[/TD]
[TD]08/20/2011[/TD]
[/TR]
[TR]
[TD]08/21/2011[/TD]
[TD]08/30/2011[/TD]
[/TR]
[TR]
[TD]10/01/2011[/TD]
[TD]10/30/2011[/TD]
[/TR]
[TR]
[TD]10/31/2011[/TD]
[TD]11/10/2011[/TD]
[/TR]
</tbody>[/TABLE]

 

[kicassrt]

Anyone have any good suggestions?