MS EXCEL - Calculate no. of working days between two dates (Networkdays Function)
Calculate employee benefits that accrue based on the number of days worked during a
specific term. The calculation includes all weekdays (Mon - Fri)
=NETWORKDAYS(startDate,endDate,[holidays])
holidays - [optional] A list of one or more dates that should be considered non-work days.
E.g- 25 Sept 2015 is written as 25
Note that the start_date, end_date and [holidays] arguments should be input as
either:
References to cells containing dates or Dates returned from formulas.
- If you attempt to input these date arguments as text, Excel may misinterpret them, due to
different date systems, or date interpretation settings Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE(2012,5,23) for the 23rd day of May, 2012. Problems can occur if dates are entered as text.
