I have a running schedule with mutlile tasks scheduled for different day # or
the same and would like to have the dates auto fill in once I enter the start
date.
example:
4/20/06 task 1 day 1
? task 2 day 2
? task 3 day 2
? task 4 day 3

Keeping in mind that I don't want to include weekends and that I'll need to
delete a range of holiday dates.

Please help. Thank you

Hi!

Use the Workday function (requires the Analysis ToolPak be installed). It
includes an argument that accounts for holidays.

Instead of entering day n, just enter the n:

4/20/06 task 1 1
formula task 2 2
formula task 3 2
formula task 4 3

The formula would be:

=WORKDAY(A$1,C2,J$1:J$5)

Copied down as needed.

J$1:J$5 would be the list of holiday dates that you want to exclude.

Biff

"JP" wrote in message
...
I have a running schedule with mutlile tasks scheduled for different day #
or
the same and would like to have the dates auto fill in once I enter the
start
date.
example:
4/20/06 task 1 day 1
? task 2 day 2
? task 3 day 2
? task 4 day 3

Keeping in mind that I don't want to include weekends and that I'll need
to
delete a range of holiday dates.

Please help. Thank you

I tried that and got the #NAME? error......

"Biff" wrote:

Hi!

Use the Workday function (requires the Analysis ToolPak be installed). It
includes an argument that accounts for holidays.

Instead of entering day n, just enter the n:

4/20/06 task 1 1
formula task 2 2
formula task 3 2
formula task 4 3

The formula would be:

=WORKDAY(A$1,C2,J$1:J$5)

Copied down as needed.

J$1:J$5 would be the list of holiday dates that you want to exclude.

Biff

"JP" wrote in message
...
I have a running schedule with mutlile tasks scheduled for different day #
or
the same and would like to have the dates auto fill in once I enter the
start
date.
example:
4/20/06 task 1 day 1
? task 2 day 2
? task 3 day 2
? task 4 day 3

Keeping in mind that I don't want to include weekends and that I'll need
to
delete a range of holiday dates.

Please help. Thank you

From Excel help:

If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in.



1.. On the Tools menu, click Add-Ins.
2.. In the Add-Ins available list, select the Analysis ToolPak box, and
then click OK.
3.. If necessary, follow the instructions in the setup program.
Biff

"JP" wrote in message
...
I tried that and got the #NAME? error......

"Biff" wrote:

Hi!

Use the Workday function (requires the Analysis ToolPak be installed). It
includes an argument that accounts for holidays.

Instead of entering day n, just enter the n:

4/20/06 task 1 1
formula task 2 2
formula task 3 2
formula task 4 3

The formula would be:

=WORKDAY(A$1,C2,J$1:J$5)

Copied down as needed.

J$1:J$5 would be the list of holiday dates that you want to exclude.

Biff

"JP" wrote in message
...
I have a running schedule with mutlile tasks scheduled for different day
#
or
the same and would like to have the dates auto fill in once I enter the
start
date.
example:
4/20/06 task 1 day 1
? task 2 day 2
? task 3 day 2
? task 4 day 3

Keeping in mind that I don't want to include weekends and that I'll
need
to
delete a range of holiday dates.

Please help. Thank you

Thank you very much for your help!

"Biff" wrote:

From Excel help:

If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in.



1.. On the Tools menu, click Add-Ins.
2.. In the Add-Ins available list, select the Analysis ToolPak box, and
then click OK.
3.. If necessary, follow the instructions in the setup program.
Biff

"JP" wrote in message
...
I tried that and got the #NAME? error......

"Biff" wrote:

Hi!

Use the Workday function (requires the Analysis ToolPak be installed). It
includes an argument that accounts for holidays.

Instead of entering day n, just enter the n:

4/20/06 task 1 1
formula task 2 2
formula task 3 2
formula task 4 3

The formula would be:

=WORKDAY(A$1,C2,J$1:J$5)

Copied down as needed.

J$1:J$5 would be the list of holiday dates that you want to exclude.

Biff

"JP" wrote in message
...
I have a running schedule with mutlile tasks scheduled for different day
#
or
the same and would like to have the dates auto fill in once I enter the
start
date.
example:
4/20/06 task 1 day 1
? task 2 day 2
? task 3 day 2
? task 4 day 3

Keeping in mind that I don't want to include weekends and that I'll
need
to
delete a range of holiday dates.

Please help. Thank you

You're welcome!

Biff

"JP" wrote in message
...
Thank you very much for your help!

"Biff" wrote:

From Excel help:

If this function is not available, and returns the #NAME? error, install
and
load the Analysis ToolPak add-in.



1.. On the Tools menu, click Add-Ins.
2.. In the Add-Ins available list, select the Analysis ToolPak box, and
then click OK.
3.. If necessary, follow the instructions in the setup program.
Biff

"JP" wrote in message
...
I tried that and got the #NAME? error......

"Biff" wrote:

Hi!

Use the Workday function (requires the Analysis ToolPak be installed).
It
includes an argument that accounts for holidays.

Instead of entering day n, just enter the n:

4/20/06 task 1 1
formula task 2 2
formula task 3 2
formula task 4 3

The formula would be:

=WORKDAY(A$1,C2,J$1:J$5)

Copied down as needed.

J$1:J$5 would be the list of holiday dates that you want to exclude.

Biff

"JP" wrote in message
...
I have a running schedule with mutlile tasks scheduled for different
day
#
or
the same and would like to have the dates auto fill in once I enter
the
start
date.
example:
4/20/06 task 1 day 1
? task 2 day 2
? task 3 day 2
? task 4 day 3

Keeping in mind that I don't want to include weekends and that I'll
need
to
delete a range of holiday dates.

Please help. Thank you