networkdays problem

[goober]

Hi. I have the following formula which calculates work days with non-Sat/Sun weekends and as a three day weekend. The problem I am having is that for excluding holidays it still works as if it is Sat/Sun weekends. Could anyone help me out with a solution.

=(NETWORKDAYS(C48+3,F48+3,S$38:S$66))-(INT((((F48+4)-(C48+4))-MOD(7-(C48+4),7))/7)+1)

Thanks.

[Ron Rosenfeld]

On Thu, 22 Dec 2005 07:44:12 -0600, goober
<[email protected]> wrote:

>
>Hi. I have the following formula which calculates work days with
>non-Sat/Sun weekends. The problem I am having is that for excluding
>holidays it still works as if it is Sat/Sun weekends. Could anyone
>help me out with a solution.
>
>=(NETWORKDAYS(C48+3,F48+3,S$38:S$66))-(INT((((F48+4)-(C48+4))-MOD(7-(C48+4),7))/7)+1)
>
>Thanks.

If your weekend days are "two" and are contiguous, then you just need to add an
appropriate offset to start_date, end_date, and holiday_dates. You may not be
adding the appropriate offset to holiday_dates in your formula.

If you have some other criteria for weekend dates, then I can post a UDF that
is more flexible.



--ron

[goober]

Thank you Ron. An offset fixed the issue I was having. I didn't realize that it would be that simple of a fix. Your help is greatly appreciated.

[Ron Rosenfeld]

On Thu, 22 Dec 2005 20:43:09 -0600, goober
<[email protected]> wrote:

>
>Thank you Ron. An offset fixed the issue I was having. I didn't
>realize that it would be that simple of a fix. Your help is greatly
>appreciated.

Thanks for the feedback. I'm glad I was able to help.

Best wishes,
--ron