| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for adding days to a date excluding weekends and holidays?
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Generating business days in a calendar month, EXCLUDING holidays | Excel Worksheet Functions | |||
| Generating business days in a calendar month, EXCLUDING holidays | Excel Worksheet Functions | |||
| How do you count work days excluding weekends and holidays? | Excel Discussion (Misc queries) | |||
| Formula - Excluding weekends & holidays | Excel Worksheet Functions | |||
| Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions | |||
Threaded Mode
