filling in dates with out weekends

ewtodd · May 16th, 2002, 07:13 AM

I cant figure out how to fill in a column with dates that will leave out the weekends. Any help would be nice

Aladin Akyurek · May 16th, 2002, 07:18 AM

Quote:

On 2002-05-16 06:13, ewtodd wrote:
I cant figure out how to fill in a column with dates that will leave out the weekends. Any help would be nice

In A1 enter your start date (which should be a work day).

In A2 enter and copy down:

=WORKDAY(A1,1)

WORKDAY is only available when the Analysis Toolpak add-in is activated (via Tools|add-Ins.

This function allows you to exclude the holidays too.

SubZero · May 16th, 2002, 07:22 AM

Highlight the 1st date, and with the right mouse button on the bottom right of that cell, drag the mouse where you want the rest of the dates to go. When you let go a menu pops up, choose series at the bottom, then choose weekdays. Job Done !

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 16th, 2002, 07:13 AM	#1
ewtodd New Member Join Date: Apr 2002 Location: Eric Posts: 3	I cant figure out how to fill in a column with dates that will leave out the weekends. Any help would be nice

May 16th, 2002, 07:22 AM	#3
SubZero New Member Join Date: May 2002 Posts: 8	Highlight the 1st date, and with the right mouse button on the bottom right of that cell, drag the mouse where you want the rest of the dates to go. When you let go a menu pops up, choose series at the bottom, then choose weekdays. Job Done !