NETWORKDAYS.INTL function

description:

Returns the number of whole workdays between two dates with custom weekend parameters.

 

syntax:

=NETWORKDAYS.INTL( start_dateend_date[weekend][holidays] )

 

required arguments:

start_date The start date.
end_date The end date.

optional arguments:

[weekend] For which days of the week should be considered weekends.
[holidays] A list of one or more dates that should be considered non-work days.