NETWORKDAYS
Returns the number of workdays between a start date and an end date. Holidays can be deducted.
NETWORKDAYS(StartDate; EndDate; Holidays; Workdays)
AlguskuupƤev on pƤev, millest arvutamist alustatakse. Kui alguskuupƤev on tƶƶpƤev, siis loetakse see esimeseks pƤevaks.
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.
PĆ¼had on mittekohustuslik pĆ¼hade loend, mis on puhkepƤevad. Sisesta lahtrite vahemik, kus pĆ¼had on Ć¼kshaaval loetletud.
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.
Kui palju tƶƶpƤevi jƤi kuupƤevade 15.12.2001 ja 15.01.2002 vahele? AlguskuupƤev asub lahtris C3 ja lƵppkuupƤev lahtris D3. Lahtrid F3 kuni J3 sisaldavad jƵulude ja uusaastaga seotud puhkepƤevi: "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.