NETWORKDAYS function in Excel is a type of DATE/TIME function. It gives value of the number of DAYS falling between two dates. This function can be applied to find the number of the days from the date present in the cell. This can also be used to extract and put the number of days into other functions, for example in DATE function. It skips weekends (Sundays and Saturdays) and can also omit any extra holidays if required.
=NETWORKDAYS(Start_date, End_date, Holidays)
- End_Date- The end date to which one wants to calculate the number of days.
- Start_Date- The start date from which one wants to calculate the number of days.
- Holidays- Any non-working days beside weekends, which are to be omitted.
- In General formatting of Excel, Dates are in form of serial numbers. Serial number 1 is for 1 JAN, 1900 and the number increases from thereon. For getting it in readable form use the formatting tab.
- The argument used must represent a valid date in Excel format.
- If the arguments used have number values which are out of range of valid excel date, #NUM error is displayed
- If the arguments used have strings which cannot be converted into valid dates, #VALUE error is displayed.
- NETWORKDAYS automatically omits weekends.
In this example, dates are given in column A and B, number of days between these dates are calculated using the NETWORKDAYS function in column C.