NETWORKDAYS(start_date,end_date,holidays) returns the number of whole workdays between two dates : NETWORKDAYS « Date Time functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Date Time functions
  3. NETWORKDAYS
Input the formula: =NETWORKDAYS(A2,A3). Press Enter to get the result.
15.9.NETWORKDAYS
15.9.1.NETWORKDAYS(start_date,end_date,holidays) returns the number of whole workdays between two dates
15.9.2.=NETWORKDAYS(A2,A3,A4) returns the number of workdays between the start and end date above, excluding the first holiday
15.9.3.=NETWORKDAYS(A2,A3,A4:A6) returns the number of workdays between the start and end date above, excluding every holiday above