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 The date at which to start the calculation

end_date The 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. The 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.

Thumbnail for the NETWORKDAYS function
YouTube Video Explaining the NETWORKDAYS Function

Related Functions

DAYS – Calculate the number of days between two dates.

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

MINUS – Subtract one value from another. The MINUS function can subtract dates.

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

Errors

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

Examples

Screen capture showing examples of NETWORKDAYS.INTL Functions
Examples of the NETWORKDAYS.INTL Functions

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.

Notes

Consider using the IMPORTXML function to obtain a list of your local holidays from the web.

4 thoughts on “NETWORKDAYS.INTL Function – Google Sheets”

  1. Hi, at my PC in windows 7, excel sheet NETWORKDAYS is giving incorrect answers. Actually i want to manage my workdays attendance and i tried it. I put 2-April-2020 in start date cell and 15-April-2020 in end date cell, the result should be 14 but it is giving 10-January-1900. I tried many times and took also google help but all in vain and time wasting. Your help would be very helpful for me. Thanks, Regards.

    Reply
    • Change the format from date to number. That sounds like a number that your spreadsheet is trying to show to you as a date.

      Reply
    • You can input it as a Custom function if you scroll all the way down through the preset options in the Conditional formatting menu.

      Reply

Leave a Comment