Workday Function Question

P

PA

I am creating a schedule to specify start and finish date of various tasks.
Some of the durtions of these tasks can be many months.
How can I have the function operate with more than one holiday.
For example, a task should start on 8/1/05 and end on 1/12/06. These dates
calulated by not counting Sat, Sun, Labor Day, Thanksgiving, Christmas and
New Years. How do I get the four holidays into the workday calculation.
Assume start is in C10, Duration is in D10,Workday is in E10 and the
holidays are in B25, B26, B27 and B28.
I tried =workday(C10,D10,(B25,B26,B27,B28))

PLease Help
Paul
 
M

malik641

You have to use NETWORKDAYS for what you want, but you have to use an
Add-In. Go to Tools->Add-Ins->Analysis ToolPak

The function works like this:

NETWORKDAYS(start_date, end_date, holidays)

This returns the value of the amount of days EXCLUDING weakends and
holidays. You can add as many holidays as you want. Just keep in mind
that when you have more than one the function would look like:

NETWORKDAYS(start_date, end_date, {holiday1, holiday2, holiday3, etc})

For the example you gave:

=NETWORKDAYS(8/15/05, 1/12/06, B25:B28)

Hope this is what you're looking for.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top