WEEKDAY Function?

[JP]

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

 

[Biff]

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]

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

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:


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

 

[Biff]

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]

Thank you very much for your help!

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

 

[Biff]

You're welcome!

Biff

Thank you very much for your help!