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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
networkdays and holidays
Put the arrival date and the order date in A1 and A2, and then put the dates
of the holidays in cells, say C1, C2, C3, etc...Select the cells with holiday dates and name the range "HOLIDAYS" using the Name Box. The formula then can read something similar to:: =NETWORKDAYS(A1,A2,HOLIDAYS) "TST" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
networkdays and holidays
Thank you. Formula works great!.
"Laura Cook" wrote: Put the arrival date and the order date in A1 and A2, and then put the dates of the holidays in cells, say C1, C2, C3, etc...Select the cells with holiday dates and name the range "HOLIDAYS" using the Name Box. The formula then can read something similar to:: =NETWORKDAYS(A1,A2,HOLIDAYS) "TST" wrote in message ... 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. |
Reply |
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 |