Hi
I can consecutively number dates down a column from 01/01/07, 08/010/7 -
31/12/07, using the edit fill series process.

I need each 7 day date to repeat down column A by 4 rows

eg:
A1 = 01/01/07
A2 = 01/01/07
A3 = 01/01/07
A4 = 01/01/07
A5 = 08/01/07
A6 = 08/01/07
A7 = 08/01/07
A8 = 08/010/7
A9 = 15/01/07 etc

the only way I can do it at the moment is to enter 01/01/07 in A1 and fill
down to the A4, enter 08/01/07 in cell A5 and fill down to A8 etc

is there a step repeat or edit fill that will do the above process by 4 rows?

thanks for your assistance