custom series for class schedule?

[Peter]

I'd like to generate a class schedule, sequentially, using Excel 2003.
If I provide a series of actual dates upon which the first week's
classes occur (e.g. 8/24, 8/24, 8/25, Tuesday 8/25, Wednesday 8/27,
etc.), can Excel automatically extrapolate the next X number of weeks
and the dates on which these classes should fall? I've fiddled around
with 'right-click -> fill series' but all Excel does is *repeat* the
same date-range, over and over. I am hoping to carry the series into the
future.

Thanks for any guidance.

Peter

 

[Earl Kiosterud]

Peter,

If you want fixed date intervals, like 7 days, put in the first two dates,
select both cells, and then drag the Fill Handle.

If you want a date a fixed number of days from a class date, use a formula
to add them:

=A2 + 42

This would add 42 days to the date in A2, giving you the resultant date six
weeks hence.