Issues with computing the number of working days, excluding weekends/holidays

Hello!

I am trying to find the way to compute the number of working days spent on fulfilling the task, but I don't understand how to achieve the correct result. WORKDAY function seems not to be a good solution for my case.

Here is the description:

In column B I have start days for each particular task
In column C I have the number of working days I plan to dedicate to the task
In column D I want to compute the end date based on the start day plus working days - holidays/weekends.

For example:

B12 January 2 2017
C12 15
Then if I know the exact amount of off days in January (for example, 14 off days stored in cell B25) I can easily use the following formula:

=IF(B12="","",WORKDAY(B12,C12,B25))

to get the end date January 23 2017

But some of the tasks can extend over a month and a half, or two, or three, etc, months. And as I need this formula to be dynamic, it doesn't make sense to use the formula if I need to compute the end date manually taking into account how many months the task takes.

I have tried to create a list of all "off" days during the year, and store them, for example, store them in B25:B40:

January 6 2017
February 14 2017
March 8 2017

etc.

and then use this formula:

=IF(B12="","",WORKDAY(B12,C12,B25:B40))

But that doesn't do the job, because I assume the formula doesn't discern the months, and simply subtracts all these dates as holidays from each task.

For example:

B12 January 2 2017
C12 36
Then if I know the exact amount of off days in January (for example, 14 off days stored in cell B25) I can easily use the following formula:

=IF(B12="","",WORKDAY(B12,C12,B25:B40))

will subtract the number of all off days stored in B25:B40 (not only the ones I need to subtract, namely off days in January and part of February), and I will end up with a wrong date.

Please, help me to solve the problem.

I will be very grateful for your help.

Thank you!

Originally Posted by Bernie Deitrick

That is the correct formula - I think you are just mis-interpreting how to use holidays. Holidays are specific dates 1/1/2017, 2/12/2017, 7/4/2017 etc. not the number of holidays per month.

Thank you for your reply. I did use this format of holidays. I will now try it again. You see, all my previous attempts did subtract all holidays of the whole year, not only those for a particular period. Do you say that this WORKDAY formula does discern months and takes holidays only of the specific period.

Originally Posted by Bernie Deitrick

That is the correct formula - I think you are just mis-interpreting how to use holidays. Holidays are specific dates 1/1/2017, 2/12/2017, 7/4/2017 etc. not the number of holidays per month.

I am sorry. I did work now. Thank you very much.