Scheduling with Work Week m-f
 

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?

Scheduling with Work Week m-f
 

Try this, assuming A1 is your starting date:

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

HTH,
Elkar


"72malibu" wrote:

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?

Scheduling with Work Week m-f
 

=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)



"72malibu" wrote in message
...
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?

Scheduling with Work Week m-f
 

How and where would i go about downloading this?

"Bob Phillips" wrote:

=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)



"72malibu" wrote in message
...
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?

Scheduling with Work Week m-f
 

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

"Bob Phillips" wrote:

=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)



"72malibu" wrote in message
...
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?

Scheduling with Work Week m-f
 

Go to ToolsAddins 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)



"72malibu" wrote in message
...
Thanks Bob, I have installed this function. Now what? Thanks.

"Bob Phillips" wrote:

=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)



"72malibu" wrote in message
...
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?

Scheduling with Work Week m-f
 

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" wrote:

Go to ToolsAddins 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)



"72malibu" wrote in message
...
Thanks Bob, I have installed this function. Now what? Thanks.

"Bob Phillips" wrote:

=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)



"72malibu" wrote in message
...
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?

Scheduling with Work Week m-f
 

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)



"72malibu" wrote in message
...
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" wrote:

Go to ToolsAddins 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)



"72malibu" wrote in message
...
Thanks Bob, I have installed this function. Now what? Thanks.

"Bob Phillips" wrote:

=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)



"72malibu" wrote in message
...
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?