| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
NetWorkDays Function Syntax
What is the syntax to add more than one "holiday" for NetWorkDays function? The below formula does not work: =NETWORKDAYS(B2,C2,"1/1/05","1/17/05") Do you have reference other cells with the dates that are suppose to be excluded? Or can you manually enter dates into the function? Thank you |
|
#2
|
|||
|
|||
|
It needs to be in brackets...
=NETWORKDAYS(B2,C2,"1/1/05",{"1/17/05","1/18/05"}) "Lamar" wrote: What is the syntax to add more than one "holiday" for NetWorkDays function? The below formula does not work: =NETWORKDAYS(B2,C2,"1/1/05","1/17/05") Do you have reference other cells with the dates that are suppose to be excluded? Or can you manually enter dates into the function? Thank you |
|
#3
|
|||
|
|||
|
Hi Lamar
Insert a list of public holiday dates, say in F1:F13 or whatever. Your formula should then read =NETWORKDAYS(B2,C2,F1:F13) "xgirl" wrote: It needs to be in brackets... =NETWORKDAYS(B2,C2,"1/1/05",{"1/17/05","1/18/05"}) "Lamar" wrote: What is the syntax to add more than one "holiday" for NetWorkDays function? The below formula does not work: =NETWORKDAYS(B2,C2,"1/1/05","1/17/05") Do you have reference other cells with the dates that are suppose to be excluded? Or can you manually enter dates into the function? Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need a ISWorkday Function -- Any Ideas | Excel Worksheet Functions | |||
| How do I install the networkdays function! | Excel Worksheet Functions | |||
| Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions | |||
| Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions | |||
| MS Excel Function - Networkdays | Excel Worksheet Functions | |||
Hybrid Mode
