Scheduling with Work Week m-f

[Guest]

I have put together a schedule, so that every column has a formula to where
each column adds 1 day to the previous. It all works well, until I have a
Saturday and Sunday. I have a 30 column spreadsheet and when I enter the
starting date, I want the days to change with the formula, except I need it
to skip Sat and Sun. I know I can do it individually, cell by cell, but that
just takes forever.
Is there any formula I can enter that will make this schedule not count
Saturdays and Sundays?

 

[Guest]

Try this, assuming A1 is your starting date:

=IF(WEEKDAY(A1)=6,A1+3,A1+1)

HTH,
Elkar

 

[Bob Phillips]

=WORKDAY(A1,1)

WORKDAY is an Analysis Toolpak function, so this needs to be installed.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

How and where would i go about downloading this?

=WORKDAY(A1,1)

WORKDAY is an Analysis Toolpak function, so this needs to be installed.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

Thanks Bob, I have installed this function. Now what? Thanks.

 

[Bob Phillips]

Go to Tools>Addins and check the Analsyis Toolpak item , then the formula
should work.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

Right. I downloaded the addin, but i still cannot figure out how to add in
that formula. If you have time, please fill me in. If not, thanks for the
info you have shared.

 

[Bob Phillips]

In your schedule, just put your start date in the first cell of the
schedule, lets say D2 for this exercise.

Then in the second day cell, add the formula

=WORKDAY(D2,1)

and just copy it down to all of the other days in the schedule.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)