View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
BekkiM
 
Posts: n/a
Default Formula for adding days to a date excluding weekends and holidays?

Use the WORKDAY function instead:

A B C
1 Task Duration Completed
2 First Task 4 01/06/06
3 Task 2 6 =WORKDAY(C2,B3,HOLIDAYS)

Where "HOLIDAYS" is a named range of all of your holiday dates (see
http://www.contextures.com/xlNames01.html for details on naming ranges)

"Jake via OfficeKB.com" wrote:

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