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.

Skillshare’s usually $10 a month, but because you’re an OfficeTuts reader you can get your first month free by clicking here. That’s unlimited access to over 18,000 classes on Excel, VBA, and much more.