Blog of Calc LLC

NETWORKDAYS.INTL function calculate the net work days between two days for countries outside of US. Syntax NETWORKDAYS.INTL(start date, end date, weekend indicator, [holidays]) Weekend indicator is a string of seven 0s or 1s indicating which days of a week are weekends. 0 indicates work days and 1 indicates weekends. The first number indicates Monday. For example, "0000011" indicates Saturday and Sunday are weekends, while "1000001" indicates Monday and Sunday are weekends. Examples Notes You can use an integer 1 to 17 as the weekend indicator. However, that is not as visual as "0000011".

NETWORKDAYS function does NOT calculate "network days" such as the number of days your computer network has been on. It calculates "net work days" -- the number of days between two dates except weekend or holidays. Syntax NETWORKDAYS(start date, end date, [holidays]) [holidays] are optional. Examples Notes You need to provide holidays by yourself. If you do not do it, all holidays will be regarded as work days.