Moving a sequence of dates

  • Thread starter Thread starter James
  • Start date Start date
J

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
 
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.
 
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.
 
Back
Top