View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
goober
 
Posts: n/a
Default networkdays problem


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