Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Date and Time > NETWORKDAYS
 

NETWORKDAYS(start_date, end_date [,holidays])

 
 Returns the number of days between two dates, excluding weekend and holidays.

 start_dateThe starting date.
 end_dateThe finishing date.
 holidaysAn array of dates to exclude.

 REMARKS
 
  		• This function is only available if you have the Analysis ToolPak add-in installed.
     
  		• This function exclude weekends and any other dates specified in the "holidays" array.
     
  		• The "date" arguments can be entered as text strings within quotation marks, as serial numbers or as results of other formulas or functions.
     
  		• If "start_date" is not a valid date, then #VALUE! is returned.
     
  		• If "end_date" is not a valid date, then #VALUE! is returned.
     
  		• If "holidays" is left blank, then only weekends will be excluded.
     
  		• The "holidays" allows you to specify bank holidays as well as any other floating holidays.
     
  		• The "holidays" can either be range of cells containing dates or an array constant of serial numbers.
     
  		• If any argument is not a valid date, then #NUM! is returned.
     
  		• This function can be used to calculate holiday entitlement that is based on the number of days worked during a specific period.
     
  		• NETWORKDAYSMISC() - Returns the number of days between two dates using a defined list of workdays.

     EXAMPLES
     
     AB
    1=NETWORKDAYS("1 Jan 2007","1 Jan 2007") = 11/1/2007
    2=NETWORKDAYS("1 Jan 2007","2 Jan 2007") = 21/2/2007
    3=NETWORKDAYS("1/1/2007","9/1/2007") = 71/3/2007
    4=NETWORKDAYS(B1,B9) = 71/4/2007
    5=NETWORKDAYS("1 Jan 2007","30 Jan 2007") = 221/5/2007
    6=NETWORKDAYS("1 Jan 2007","31 Jan 2007") = 231/6/2007
    7=NETWORKDAYS("1 Jan 2007","1 Feb 2007") = 241/7/2007
    8=NETWORKDAYS("30 Jan 2007","02 Feb 2007") = 41/8/2007
    9=NETWORKDAYS("31 Jan 2007","02 Feb 2007") = 31/9/2007
    10=NETWORKDAYS("1 Jan 2007","31 Dec 2007") = 261 
    11=NETWORKDAYS("14 Jan 2007","1 Jan 2007") = -10 
    12=NETWORKDAYS(1/1/2007,31/12/2007) = 0 
    13=NETWORKDAYS(DATE(2007,1,1),DATE(2007,12,31)) = 261 
    14=NETWORKDAYS(DATE(2007,1,1),DATE(2007,12,31),"2 Jan 2007") = 260 
    15=NETWORKDAYS(DATE(2007,1,1),DATE(2007,12,31),{"2 Jan 2007","3 Jan 2007"}) = 259 
    16=NETWORKDAYS("1/30/1998","invalid dates") = #VALUE! 
    17=NETWORKDAYS("some text","2007/12/01") = #VALUE! 
    		 
     Functions - N | Index - N | Dates & Times | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top