WEEKDAY Function?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
Click to expand...

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
 
I tried that and got the #NAME? error......

Biff said:
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
Click to expand...
 
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
 
Thank you very much for your help!

Biff said:
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
Click to expand...
 
Back
Top