Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
networkdays and holidays
I am currenlty using networkdays formula to cacluate the number of days it
takes for a product to arrive to our company. (i.e. arrival date - order date = lead time). How can I modify networkdays to not count certain holidays. Would it be possible to have another worksheet that I can store holidays so the formula does not count that day? Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Removing holidays and weekends , networkdays | Excel Discussion (Misc queries) | |||
Removing holidays and weekends , networkdays | Excel Discussion (Misc queries) | |||
Ignoring weekends & holidays-NETWORKDAYS? | Excel Worksheet Functions | |||
Holidays | Excel Worksheet Functions | |||
Use networkdays INCLUDE weekends, Exclude holidays | Excel Worksheet Functions |