Compare dates and insert a missing date in a new row

[yousef9]

This is what I would like to do.
The first column of my spreadsheet could have text and date values; as follows:
12/5/2000
12/6/2000
12/9/2000
Subtotal

1/1/2001
1/2/2001
1/3/2001
subtotal
GrandTotal

I would like a macro to be applied to the first column. The macro needs to realize that there is a gap in the dates after 12/6/2000 and and before 12/9/2000. I want the macro to insert the missing dates in 2 new rows
12/7/200
12/8/2000

So the spreadwheet should look like:

12/5/2000
12/6/2000
12/7/2000
12/8/2000
12/9/2000
Subtotal

1/1/2001
1/2/2001
1/3/2001
subtotal
GrandTotal

_________________
regards-
Yousef
This message was edited by yousef9 on 2002-04-16 20:03

 

[yousef9]

On 2002-04-16 20:01, yousef9 wrote:
This is what I would like to do.
The first column of my spreadsheet could have text and date values; as follows:
12/5/2000
12/6/2000
12/9/2000
Subtotal

1/1/2001
1/2/2001
1/3/2001
subtotal
GrandTotal

I would like a macro to be applied to the first column. The macro needs to realize that there is a gap in the dates after 12/6/2000 and and before 12/9/2000. I want the macro to insert the missing dates in 2 new rows
12/7/200
12/8/2000

So the spreadwheet should look like:

12/5/2000
12/6/2000
12/7/2000
12/8/2000
12/9/2000
Subtotal

1/1/2001
1/2/2001
1/3/2001
subtotal
GrandTotal

_________________
regards-
Yousef
This message was edited by yousef9 on 2002-04-16 20:03