NETWORKDAYS.INTL Function – Google Sheets

The NETWORKDAYS.INTL calculates the number of working days between two dates. The function excludes weekends (which may or may not be Saturday and Sunday) and can exclude holidays if you provide a list.

Syntax

=NETWORKDAYS.INTL(start_date,end_date,[weekend day(s)],[holiday(s)])

start_date Date at which to start the calculation

end_date Date at which to end the calculation

[weekend day(s)] An optional description of which days are weekends.

  • Number method
    • 1 – Saturday and Sunday [don’t need to specify]
    • 2 – Sunday and Monday
    • 3 – Monday and Tuesday
    • 4 – Tuesday and Wednesday
    • 5 – Wednesday and Thursday
    • 6 – Thursday and Friday
    • 7 – Friday and Saturday
    • 11 – Sunday only
    • 12 – Monday only
    • 13 – Tuesday only
    • 14 – Wednesday only
    • 15 – Thursday only
    • 16 – Friday only
    • 17 – Saturday only
  • String method – Each digit represents a day. First digit is Monday.
    • 0000011 – Saturday and Sunday
    • 0100000 – Only Tuesday

[holiday(s)] An optional list of holidays to exclude from the count of days.

Related functions

DAYS – Calculate the number of days between two dates.

DATEDIF – Calculate length of time between two dates in years, months, and/or days.

MINUS – Subtract one value from another. Can be done with dates.

NETWORKDAYS – Calculate the number of working days without the weekend modifications of NETWORKDAYS.INTL

Errors

#VALUE! – The inputs are something that isn’t a valid date such as “The other day” or “Yester-yester-day”.

Examples

 Live examples in Sheets

Go to this spreadsheet for the examples of the NETWORKDAYS.INTL function shown above that you can study and use anywhere you would like.

WORKDAY.INTL Function – Google Sheets

The WORKDAY.INTL function calculates a workday a given number of days away from a date. You can optionally specify a list of holidays to exclude from the count and different weekends. If your days, months, and years are in different cells, use the DATE function to combine them. This function is different from the WORKDAY function because you can also specify different weekends.

Syntax

=WORKDAY.INTL(start_date,days,[weekend],[holidays])

  • start_date – The date from which to start counting the days.
  • days – The number of days to add to the start_date
  • [weekend]
    • Number method
      • 1 – Saturday and Sunday [don’t need to specify]
      • 2 – Sunday and Monday
      • 3 – Monday and Tuesday
      • 4 – Tuesday and Wednesday
      • 5 – Wednesday and Thursday
      • 6 – Thursday and Friday
      • 7 – Friday and Saturday
      • 11 – Sunday only
      • 12 – Monday only
      • 13 – Tuesday only
      • 14 – Wednesday only
      • 15 – Thursday only
      • 16 – Friday only
      • 17 – Saturday only
    • String method – Each digit represents a day. First digit is Monday.
      • 0000011 – Saturday and Sunday
      • 0100000 – Only Tuesday
  • [holidays] – Optional specification of which days are to be excluded from the count of work days.

Related functions

WEEKDAY – Returns the week number for a given date.

DAYS – Find the number of days between two dates.

NETWORKDAYS.INTL – Calculate the number of working days in between two days and exclude specified days as weekends.

NETWORKDAYS – Calculate the number of working days in between two days and exclude weekends.

WORKDAY – Like this function but with Saturday and Sunday as the weekends only.

Errors

#NUM – The inputs are numbers but are not valid dates. This could happen if you used the 35th day of November, “11/35/2018”.

#VALUE! – The inputs are something that doesn’t convert to a number such as “The other day” or “Yester-yester-day”.

 Live examples in Sheets

Go to this spreadsheet for the examples of the WORKDAY.INTL function shown above that you can study and use anywhere you would like.