MS Excel question

[Rhone]

Hey OOTers,

I'd like to have a year's worth of dates in a column:

1/1/05
1/2/05
1/3/05
.
.
.
etc.

Anyone know of a way to type the first one in and get the program to generate the rest?

thanks!

[Evan]

type "1/1/05" into A1
type "=a1+1" in A2
press enter
click a2
put your mouse over the bottom right corner of the cell (it will turn to a thin plus sign (+)
click and drag down

[kerssens]

type the first couple to create the pattern, hi-lite them and drag down from one of the corners

[jakethebake]

[ QUOTE ]
type the first couple to create the pattern, hi-lite them and drag down from one of the corners

[/ QUOTE ]

This is correct. And it's ootiots!