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.
2. For example
There is a data sheet to calculate the total number of employees working days.
2.1. Calculate the total working days without holidays
Enter the formula NETWORKDAYS (C3, D3) .
2.2. Calculate the total working day with 1 day off
For Tran Minh employees, there is one public holiday -> total working days minus holidays.
Enter the formula: NETWORKDAYS (C3, D3, I3).
2.3. Calculate the total number of working days with more than 1 day off
With Vu Hang employees have 2 days off sick and holidays -> enter the formula: NETWORKDAYS (C4, D4, E4: E5).
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!
You should read it
- How to use the NPER function in Excel to plan loans and savings
- Basic Excel functions that anyone must know
- How to use Hlookup function on Excel
- How to use the SUM function to calculate totals in Excel
- Instructions on how to use the Dmax function in Excel
- How to use the LEN function in Excel
- How to use the RANDARRAY function to randomly classify data in Excel
- How to use COUNTIF function on Excel
May be interested
- How to use COUNTIF function on Excelthe countif function on excel is the cell count function to satisfy the given condition, often used in statistics tables.
- How to use the MOD function and QUOTIENT function in Excelinjury in excel has many ways of doing it, can be used manually or using the calculation function.
- 8 little-known Excel functions that can save you a lot of workeven seasoned excel users often find themselves stuck performing tasks manually that could be automated with a few clever functions.
- How to use MID functions to get strings in Excelmid function in excel is a function that takes the middle character string corresponding to the value that the user requires to perform.
- How to use Excel's VALUE functionexcel's value function will convert a string to a digital form, which can be combined with other functions such as left function, right function, mid function.
- Instructions for using the TRIMRANGE function to clean up Excel tablestrimrange is a brand new excel function that is being rolled out to users. this new function has the ability to remove blank rows from a range of data.
- How to use the function to delete spaces in Exceldeleting white space with functions in excel makes it easier for users to handle content, instead of traditional editing.
- How to fix the SUM function doesn't add up in Excelin the process of summing with sum in excel, you will encounter some errors such as not jumping the number, not adding the sum. so how to handle this problem?
- Instructions on how to count words in cells in Excelin many cases you want to count the number of characters in a text string (text string) to calculate or combine with other functions, or to do something. you can then use the trim function, combining the len function, the substitute function. using the trim function to remove spaces, use the substitute function to replace the current text with new text in a text string, ...
- How to use the SUBTOTAL function in Excelthe subtotal function in excel is used in many different cases, helping you to sum subtotals in a list or database, unlike the sum function in excel such as counting cells, calculating average, finding the largest / smallest value. or sum the filtered list values in excel