Moving a sequence of dates

[James]

Hello I have the folowing set-up:

03/11/2003 04/11/2003

08:00
08:15
08:30
08:45
09:00

Where by the dates are along the top and the times down
the side. Basically what I am asking is I have set out two
weeks worth of dates (which are mon-friday not including
sat and sun). This is so that excel can see the pattern
but when I use the little cross in the corner of the cell
and drag accross all I get are hashes(#######) yet the
setup of teh cells is corret but even if it does show the
dates its showing ones I already have on screen rather
than continuing the pattern.

How can I achieve this?

Many Thanks

James

 

[Arvi Laanemets]

Hi

To continue using drag-and-drop, you must have at least 2 values entered.
I.e. enter 2 first dates/times, select them both, and then drag to range you
want. (And then delete Saturday-Sunday columns.)

When you get #####'s in cells, when the column isn't wide enough to show
number or date or time.

 

[J.E. McGimpsey]

Select your last date. Right click the fill handle (lower right
corner of the cell). Drag across as far as needed. Select Fill
Weekdays from the pop-up menu.