Calculate Working Days, Excluding Weekend and Holidays in Excel

Summary

The Excel NETWORKDAYS helps to calculate the working days between two dates. This function automatically exclude the weekends (Saturday & Sunday). Whereas, this function have option to exclude list of Holidays.

Purpose

Helps to calculate the working days between two dates

Syntax

= NETWORKDAYS (start_date, end_date, [holidays])

Arguments

start_date: The start date
end_date: The end date
holidays: This argument is optional and have list of non-work days in the format of dates
Networkdays in excel

Example Explanation

In above mentioned example we have showcase the working days from Jan 1, 2020 to Dec 31, 2020. In additions, we are excluding holidays from the mentioned dates. Formula used in Cells are:
CellFormula in CellExclude
D6=NETWORKDAYS(B6,C6)Weekends only
D7=NETWORKDAYS(B7,C7,$G$6:$G$7)Weekends + Holidays
D8=NETWORKDAYS(B8,C8)Weekends only
D9=NETWORKDAYS(B9,C9,G6:G7)Weekends + Holidays

Important Point

Networkdays include both start and end date while calculating working days.
scroll to top