The NETWORKDAYS function calculates and returns the number of whole work days between two supplied dates. This includes all weekdays (Mon – Fri), excluding a supplied list of holidays.
|start_date||The start of the period for which we are counting days (the start date is counted in the returned number of days)|
|end_date||The end of the period for which we are counting days (the end date is counted in the returned number of days)|
|[holidays]||An optional argument, which specifies an array of dates (in addition to weekends) that are not to be counted as working days|
Note: the start_date, end_date and [holidays] arguments should be input as either:
- References to cells containing dates, or
- Dates returned from formulas
If date arguments are entered as text, Excel may misinterpret them, due to different date interpretations by different systems or settings.
Warning: Although you can input date arguments as date serial numbers, this is not recommended as date serial numbering does vary across different computer systems.
|2||1/1/2014||12/31/2014||=NETWORKDAYS(A2,B2)||261||Weekends have been excluded|
|4||12/23/2014||12/31/2014||=NETWORKDAYS(A4,B4,B7:B8)||5||Weekend and holidays excluded|
Usage note: NETWORKDAYS can be used to calculate employee benefits that accrue based on days worked, the number of working days available in a certain time range.
Common Function Error(s)
|Problem||What went wrong|
|#VALUE!||Occurs if any of the supplied arguments are not valid dates|
|#NAME?||Occurs when Excel does not recognise a function name. This may be because you have made a mistake when typing the NETWORKDAYS function name into Excel|