WEEKDAY Function?
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
|