Auto filling dates

[goldcomac]

I have a spreadsheet that has the date in Column B. It starts off in
Cell 15 as 1/4/09, Cell 16 is 1/5/09 . . . Cell 21 is 1/10, Cell 22 is
blank, and Cell 23 starts the week over (1/11.) As you can see, I have
7 Cells with dates, then a blank cell.

1/4/09
1/5/09
1/6/09
1/709
1/8/09
1/9/09
1/10/09
BLANK
1/11/09
etc

The way I've been entering the information so far is by hand. If I
didn't have a blank cell I know I could enter a couple of dates and
then click and drag to complete the year, but because of the blank
cell I don't know if I can automate the task or not. Can I?

Thank you.

Chip

 

[Bernard Liengme]

You could enter them all the way you mention and insert blank rows later
or
How about a VBA subroutine to do the whole job? Would that interest you?
best wishes

 

[Chip M]

You could enter them all the way you mention and insert blank rows later
or
How about a VBA subroutine to do the whole job? Would that interest you?
best wishes

I don't know anything about VBA; I've only know what it stands for.