Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Based on MSFT's help for the NETWORKDAYS function (http://
support.microsoft.com/kb/259200) it appears that this function only works with holidays. Is there an equivalent function that will count the number of week days (i.e., excluding Saturday and Sunday) between two dates? I'm not necessarily interested in excluding holidays but rather Saturdays and Sundays. The time interval I'm looking at is a decade or so, so I would rather not, for example, have to create a list of all days between 1.1.1990 and 12.31.1999, isolate the Saturdays and Sundays, and use those as the [holidays] argument in the NETWORKDAYS function. Thanks for any insights. Presumably I *could* use SUMPRODUCT on a list of dates/days of the week as described above. But there's got to be an easier way. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
NETWORKDAYS function | Excel Discussion (Misc queries) | |||
Nesting Networkdays function inside and If function | Excel Worksheet Functions | |||
NETWORKDAYS FUNCTION, Help please | Excel Worksheet Functions | |||
networkdays function help | Excel Worksheet Functions | |||
Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions |