Calculate End Date (excluding weekends and holidays)

[guitaronmyback]

Hello,

I have a start days and a number (representing days for a given project). I
want to calculate the end date and exclude weekends and certain holidays.

Is this possible?

Thank you

 

[Domenic]

Hello,

I have a start days and a number (representing days for a given project). I
want to calculate the end date and exclude weekends and certain holidays.

Is this possible?

Thank you

Have a look at the WORKDAY function...

 

[Mike H]

Hi,

Try this

=WORKDAY(B1,25,Holidays)

Where

B1=start date
25 is the days for the project
Holidays is a named range containing holoiday dates.

Mike

 

[guitaronmyback]

Thank you for the tip, but I got the #name? as a result

 

[Rick Rothstein]

The WORKDAY function requires the Analysis ToolPak add-in to be loaded.
Click Tools/Add-Ins from Excel's menu bar and put a check mark next to the
Analysis ToolPak item.

 

[guitaronmyback]

It worked, but it seemed to add an extra day....10 workdays, starts on a
Monday and the final date was a Monday, when it should be a Friday....any way
of fixing that?

 

[Rick Rothstein]

Subtract 1... the difference is because you are thinking "counting numbers"
as opposed to "subtraction of two numbers"... 1, 2, 3, 4 5 is five counting
numbers but the difference between 1 and 5 is four.