How to create a formula to create a list of dates in a column

[Leo]

Hello, I am a teacher and I have to develop a course matrix. The course
has a duration of 2 months. I would like to come up with a formula that
allows me to write the first date in the column (i.e Tuesday, September
26, 2006 ) and the program write the rest of the dates all the way to
the end of the course.
Thanks
Leo

 

[Bob Greenblatt]

Hello, I am a teacher and I have to develop a course matrix. The course
has a duration of 2 months. I would like to come up with a formula that
allows me to write the first date in the column (i.e Tuesday, September
26, 2006 ) and the program write the rest of the dates all the way to
the end of the course.
Thanks
Leo

Just format the column for dates in the manner desired. Then simply add 1 to
the value in the prior cell and fill down for the length needed.

 

[CyberTaz]

Assuming you want to include _all_ dates rather than just weekdays,
once you type the starting date & format the cell, go to
Edit>Fill>Series. Select Column, confirm Date & Step Value: 1, then
type the ending date in the Stop Value: box (probably 11/25/2006 in
this case). When you click OK the list of dates will be generated.

HTH |:>)