dragging dates down while excluding sats and suns

[Guest]

In cell a5 i entered the date 11/1/04 and then i needed to continue down the
column and fill in consecutive dates until i reached lets say dec 31. I did
this by entering the first date of 11/1/04 and then dragged the bottom right
corner down until i had about two months filled in (every two months i will
be reentering the following two months) HOWEVER, i want to exclude saturdays
and sundays. Can this be done without doing it manually.

 

[Debra Dalgleish]

Select cell A5
Point to the fill handle (the black square at the lower right of the
selection)
When the pointer changes to a black cross, hold the RIGHT mouse button,
and drag down.
Release the mouse button, and from the shortcut menu, choose Fill Weekdays.

 

[Guest]

Thank You Debra.

Select cell A5
Point to the fill handle (the black square at the lower right of the
selection)
When the pointer changes to a black cross, hold the RIGHT mouse button,
and drag down.
Release the mouse button, and from the shortcut menu, choose Fill Weekdays.