Excel FunctionsLesson 99Free preview
NETWORKDAYS
This lesson is part of Excel · All levels
Summary
NETWORKDAYS is an Excel function that calculates the number of working days between two dates, which are Monday through Friday, excluding weekends. The syntax is. Also available for weekend patterns that can be set.
Key points
- Syntax: NETWORKDAYS(tanggal_mulai, tanggal_akhir, [tanggal_libur])
- Count the working days Monday-Friday, Saturday-Sunday excluded
- Start and end dates are counted if it falls on a working day
- NETWORKDAYS.INTL supporting custom weekend patterns
Full lesson
Code examples and quizzes
Full lessons, code examples, and quizzes are available to subscribers. 5 questions.