Fill in the first cell. Then select the first TWO cells (1/1/06 and blank).
Grap the fill handle at the extreme lower right of the selected cells and
drag until you've reached the ending cell (the tip will show you the value of
the latest cell you've covered).

"WmBrown" wrote:

Newbie

Is there an action to automatically fill a series of dates?

Row A1 01/01/2006
Row B1 Blank
Row C1 01/02/2006
Row D1 Blank
Row E1 01/03/2006
etc.

Thanks for any help