Ok I have done some searching on this forum and others but can't seem to find
the answer i am looking for so hopefully somebody can help me. I am trying
to setup a sheet that will produce production dates for me. My problem is
that we do not work on the weekends or holidays. I have one formula that
calculates the number of days a process takes to complete and I link that to
the date the previous process ended. For example if the last process ended
on a thursday and the next process takes 3 days I want the formula to skip
over the saturday and sunday when it calculates what day the process will
finish. I have tried to use the NETWORKDAYS function but I can't seem to get
that to work. Any help is greatly appreciated as I seem to be fairly
braindead today and cant figure it out myself. Thanks alot!!

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200601/1