LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 187
Default NETWORKDAYS function

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
NETWORKDAYS function kippers Excel Discussion (Misc queries) 2 June 19th 07 02:30 PM
Nesting Networkdays function inside and If function Addison Excel Worksheet Functions 2 April 13th 06 08:04 PM
NETWORKDAYS FUNCTION, Help please BiggyTwo Excel Worksheet Functions 0 March 29th 06 03:05 PM
networkdays function help Deb Bagby Excel Worksheet Functions 3 November 1st 05 05:36 PM
Nested IF Function, Date Comparing, and NetworkDays Function carl Excel Worksheet Functions 2 December 29th 04 09:57 PM


All times are GMT +1. The time now is 02:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"