NETWORKDAYS
Returns the number of workdays between a start date and an end date. Holidays can be deducted.
NETWORKDAYS(StartDate; EndDate; Holidays; Workdays)
StartDate is the date from when the calculation is carried out. If the start date is a workday, the day is included in the calculation.
EndDate is the date up until when the calculation is carried out. If the end date is a workday, the day is included in the calculation.
Holidays is an optional list of holidays. These are non-working days. Enter a cell range in which the holidays are listed individually.
Workdays is an optional list of number values defining standard work week. This list starts by Sunday, workdays are indicated by zero and non-working days by non-zero value.
Quants dies feiners hi ha entre el 15/12/2001 i el 15/01/2002? La data inicial s'ubica a la cel·la C3 i la data final a la cel·la D3. Les cel·les F3 a J3 contenen els festius de Nadal i de Cap d'Any següents: «24/12/2001», «25/12/2001», «26/12/2001», «31/12/2001», «01/01/2002».
=NETWORKDAYS(C3;D3;F3:J3) returns 17 workdays.
How many workdays fall between September 12nd and 25th in 2016 if only Mondays, Tuesdays and Wednesdays are considered as workdays?
=NETWORKDAYS(DATE(2016;9;12); DATE(2016;9;25); ; {1;0;0;0;1;1;1}) returns 6 workdays.