Tuesday, January 29, 2013

yogi_A Single Formula WorkAround For Using NETWORKDAY Function For An Array Of Values


                                          Google Spreadsheet  Post  #995

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Jan 29, 2013
user luis seyler said:(http://productforums.google.com/forum/?zx=4yxtidi1aog8#!category-topic/docs/spreadsheets/eMybzyMnSTs)
workdays with 2 columns
Hi, I just wanted to know if there is a way to see the workdays of 2 diff columns and the answer in a third column, like workdays startdates would be in comlumn A and finish date would be in column B and column C would have the answer of each pair.
---
yes, I mean those days, I know the networkdays function can give me that, but I cant grab 2 columns, I have to do it one pair of date at a time, like NETWORKDAYS(A1,B1)  NETWORKDAY(A2, B2), I wanted to do something like NETWORKDAYS (A, B) refering the dates from A1 to AX as startdate and from B1 to BX as finish date, and the column C would have the result of each of the NETWORKDAYS(Ai, Bi)  like Ci = NETWORKDAYS (Ai, Bi) for i = 1 to i=n.
--------------------------------------------------------------------------------------------
 NETWORDAY function can not be used with an array of values ... so in the following I have presented a single formula  WorkAround for computing Net Working Days for an array of Start and End dates