date in column how to in Excel

[JebusRocks]

Hello

I rookie Excel question I think

I am creating a spreadsheet and would like the first column to hold the date starting with today’s date and increasing by one day for each cell working down the column.
Other than manually entering the date into each cell is there a automated way of doing this?

Thanks

 

[GlennUK]

Activate the first cell, and do Ctrl-; ( i.e. hold the Control key down, and press ; ), which will type todays date into a cell.

Then in the cell below this type =cellref-1 where cellref is the reference of the first cell, and then copy that as far down as you require.


Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[xlbo]

Glenn - you mean =cellref + 1 I presume ;-)

Rgds, Geoff

"Having been erased. the document thjat you are seeking. Must now be retyped"

Please read FAQ222-2244 before you ask a question

 

[GlennUK]

LOL, yep phat finger problems.


Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[barbola]

Here is how to use "Fill" according to Excel help:

Fill in a series of numbers, dates, or other items:
Select the first cell in the range you want to fill, and then enter the starting value for the series.
To increment the series by a specified amount, select the next cell in the range and enter the next item in the series. The difference between the two starting items determines the amount by which the series is incremented.

Select the cell or cells that contain the starting values.


Drag the fill handle over the range you want to fill.
To fill in increasing order, drag down or to the right.

To fill in decreasing order, drag up or to the left.

Notes

To specify the type of series, use the right mouse button to drag the fill handle over the range, and then click the appropriate command on the shortcut menu. For example, if the starting value is the date JAN-2002, click Fill Months for the series FEB-2002, MAR-2002, and so on; or click Fill Years for the series JAN-2003, JAN-2004, and so on.


To manually control how the series is created, or use the keyboard to fill in a series, use the Series command.



Thanks!
Barb E.

 

[JebusRocks]

thanks everyone, just what I was looking for.