J
Jake via OfficeKB.com
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!!
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!!