Reference a cell with a date in it

[excelboy9317]

I am looking for a macro that willl do the following:

• I have a date in cell A12
• I want to put that date in each cell of column b as long as the corresponding cell in column a has a number in it.
• After all dates are entered, I want the macro to skip two lines and start again, but this time add one day to the previous date.

Can someone help me on this?

[coreytroy]

Define 'After all the dates are entered' ?
Does that mean when there is no value in a corresponding Column A cell?

[excelboy9317]

yes thats correct. The corresponding A cell in column a would ba blank for two cells and then the column would start containing values again.

[excelboy9317]

Here is a screen shot with a little more detail on what Im wanting to do......

excelexample.JPG