I am trying to create a spread sheet that has a column that is stricly dates that include the dates from now until 2 years from now. I want there to be 6 spaces or rows between each date, and i dont want to do it manually.....anyone know how i can do that?

does it make sense?

7/18/2007 1:57:59 PM

[start date]
blank cell
blank cell
blank cell
blank cell
blank cell
blank cell
[next date]
blank cell
blank cell
blank cell
blank cell
blank cell
blank cell


1. highlight the above.
2. grab the handle in the lower right hand corner and extend.
3. profit

7/18/2007 2:01:11 PM

that would probably do it...

7/18/2007 2:02:24 PM

^^ that's what i was thinking too. didn't work in excel 2007 though

[Edited on July 18, 2007 at 2:04 PM. Reason : might work for 2003]

7/18/2007 2:03:53 PM

hell yeah, man. You are the shit!

7/18/2007 2:04:16 PM

That worked for me in 2007. I didn't know you could do that. That's a hell of a lot easier then the way I would have done it.

7/18/2007 2:09:37 PM

yup, for 03 it worked....limpynut's plan worked

7/18/2007 2:11:49 PM

for 2007, it worked if typing date literals in A1 and A8, but not when A1 and A8 are references to other cells

7/18/2007 2:17:43 PM

Ah. yeah, I just typed in two dates.

Seriously though, I'm ashamed to admit how I would have solved this otherwise.

7/18/2007 2:22:20 PM

BRUTE FORCE

7/18/2007 4:00:34 PM