software

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.--
goober
------------------------------------------------------------------------
goober's Profile: www.excelforum.com/member.php...oamp;userid=19838
View this thread: www.excelforum.com/showthread...hreadid=495485On Thu, 22 Dec 2005 07:44:12 -0600, goober
gt; wrote:

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

If your weekend days are quot;twoquot; 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


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.--
goober
------------------------------------------------------------------------
goober's Profile: www.excelforum.com/member.php...oamp;userid=19838
View this thread: www.excelforum.com/showthread...hreadid=495485On Thu, 22 Dec 2005 20:43:09 -0600, goober
gt; wrote:

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

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

Best wishes,
--ron