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:
http://www.excelforum.com/member.php...o&userid=19838
View this thread:
http://www.excelforum.com/showthread...hreadid=495485