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?

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?

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

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?

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?

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?

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?

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?