How to use Excel NETWORKDAYS.INTLFunction

Introduction

NETWORKDAYS.INTL 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) by default but gives an option of defining which days should be considered as weekends and can also omit any extra holidays if required.

Syntax

==NETWORKDAYS.INTL(Start_date, End_date, Weekend, Holidays)

Arguments

  • 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.
  • Weekend- An option used to define which days should be considered as weekends.

Keynotes

  • 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.
  •  It skips weekends (Sundays and Saturdays) by default but gives an option of defining which days should be considered as weekends and can also omit any extra holidays if required.

Examples

In this example, dates are given in column A and B, number of days between these dates are calculated using the NETWORKDAYS.INTL function in column C.

Leave a Comment