Functions
NETWORKDAYS.INTL
Working days between dates with custom weekends
Try it
When to use it
When should I use NETWORKDAYS.INTL instead of NETWORKDAYS?
Use NETWORKDAYS.INTL when your working week differs from Mon–Fri, for example in the Middle East where the weekend may be Friday–Saturday, or for any custom weekend pattern.
Used in
operations · hr
Syntax
NETWORKDAYS.INTL(start,end,[weekend],[holidays])Examples
=NETWORKDAYS.INTL(DATE(1969,7,16),DATE(1969,7,24),1) // => 7
=NETWORKDAYS.INTL(DATE(1969,7,16),DATE(1969,7,24)) // => 7
=NETWORKDAYS.INTL("12/04/1995","12/22/1995",3) // => 13