SummaryThe 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.
PurposeHelps to calculate the working days between two dates
Syntax= NETWORKDAYS (start_date, end_date, [holidays])
Argumentsstart_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
Example ExplanationIn 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:
|Cell||Formula in Cell||Exclude|
|D7||=NETWORKDAYS(B7,C7,$G$6:$G$7)||Weekends + Holidays|
|D9||=NETWORKDAYS(B9,C9,G6:G7)||Weekends + Holidays|
Important PointNetworkdays include both start and end date while calculating working days.