Instructions for using the Networksday function in excel

The following article details the calculation of workdays using Networksday.

1. Structure and meaning of functions

- Structure: Networksday (start_day, end_day, [holidays]) .

Inside:

+ start_day: The start date.

+ end_day: End date.

+ [holidays]: Holidays.

- Meaning: The function returns the total number of working days except weekends and holidays.

There is a data sheet to calculate the total number of employees working days.

Instructions for using the Networksday function in excel Picture 1

Enter the formula NETWORKDAYS (C3, D3) .

Instructions for using the Networksday function in excel Picture 2

For Tran Minh employees, there is one public holiday -> total working days minus holidays.

Enter the formula: NETWORKDAYS (C3, D3, I3).

Instructions for using the Networksday function in excel Picture 3

With Vu Hang employees have 2 days off sick and holidays -> enter the formula: NETWORKDAYS (C4, D4, E4: E5).

Instructions for using the Networksday function in excel Picture 4

Note: You should apply the formula in " 2.3 Calculating the total working days with more than 1 day off " for all cases.

Good luck!

Kareem Winters

Update 19 May 2020

Normalize string when pressing Enter key in Excel
the following article will guide in detail how to use functions to normalize strings when pressing the enter key in excel. this function will remove spaces at the beginning and end of the line, delete two consecutive white space characters between words.
Instructions to merge multiple Excel files into 1 File
detailed instructions on how to combine multiple excel files into a single file with macro.
Count the number of Saturdays and Sundays in any period in Excel
instructions to count the number of saturdays and sundays in any period in excel. the following article details how to calculate the number of 7th, sunday or any day in excel in many ways.
Summary of data from multiple Sheets in Excel
the following article details how to aggregate data from multiple sheets in excel.
Split numbers from strings in Excel
in the process of working with excel, i have encountered some cases that require separating only the fraction in a given string, now this post shares with you how to do this. the following article details how to separate numbers from a given string in excel.
Calculate by cell background color in Excel
detailed instructions on how to sum data cells by cell background color in excel by building a macro function that calculates the cell background color. example: the colors have corresponding values. sum the values corresponding to the cell's background color.