NETWORKDAYS Function Explained
The NETWORKDAYS Function in Microsoft Excel calculates the number of working days between two given dates, excluding weekends and holidays. It takes two arguments: the start date and the end date. It returns the number of working days between the two dates.
NETWORKDAYS Function Syntax
NETWORKDAYS(start_date, end_date, [holidays])
- start_date: The start date of the period to consider for counting workdays.
- end_date: The end date of the period to consider for counting workdays.
- holidays: (Optional) An optional range of one or more dates to exclude from the working calendar, such as state and federal holidays and other observed holidays.