Adding Work Days only in a function?

[Guest]

How would you advise going about the following.

I have a column for project start dates. I have another column indicating
duration for the project in terms of work days. How would you calculate the
end date? Adding the duration would not account for weekend? Thoughts?

 

[Jason Morin]

Use the NETWORKDAYS worksheet function. Make sure the
Analysis ToolPak is installed under Tools > Add-Ins. See
XL help file.

HTH
Jason
Atlanta, GA

 

[Ron Rosenfeld]

How would you advise going about the following.

I have a column for project start dates. I have another column indicating
duration for the project in terms of work days. How would you calculate the
end date? Adding the duration would not account for weekend? Thoughts?

=WORKDAY(start_date, duration, holidays)

Holidays is an optional range of holiday dates.

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

How?

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


--ron

 

[Guest]

Thank you Ron Rosenfeld. I was waiting to ask for
this formula.

RobertR

 

[Ron Rosenfeld]

Thank you Ron Rosenfeld. I was waiting to ask for
this formula.

RobertR

You're welcome. Look in HELP for further details of the function.


--ron