close
How can I change a weekend day defult in the networkdays function in the
excel sheet ?
Here is an alternative formula
=SUMPRODUCT(--(ISNUMBER(MATCH(WEEKDAY(ROW(INDIRECT(end_dateamp;quot;:quot;amp; start_date))
),{2;3;4;5;6},0))))-SUMPRODUCT(ISNUMBER(MATCH(WEEKDAY(holidays),{2;3;4 ;5;6},
0))*(holidaysgt;=start_date)*(holidayslt;=end_date))
where the array constants {2;3;4;5;6} refers to the days of the week that
you want to include, which is Mon-Fri in this example.
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
quot;fadi0007quot; gt; wrote in message
...
gt; How can I change a weekend day defult in the networkdays function in the
gt; excel sheet ?
全站熱搜
留言列表
