View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
daddylonglegs
 
Posts: n/a
Default Calculating Dates Using Different Values for NETWORKDAYS


If start date is in A1 and positive number of business days in B1

=SMALL(IF(WEEKDAY(A1+ROW(INDIRECT("1:"&B1*3))-1)={2,4,6},A1+ROW(INDIRECT("1:"&B1*3))-1),B1)

confirmed with CTRL+SHIFT+ENTER

note that {2,4,6} refers to Mon, Wed and Fri. Adjust accordingly for
other combinations


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=534245