Use NETWORKDAYS to tabulate the number of days between a starting date and an ending date while ignoring weekend dates. Also, you can cross-reference a list of holidays and have them not be included in the calculation. The companion function NETWORKDAYS.INTL provides options for different weekend days.
- [voiceover] This worksheet is called NET WORK DAYS.…Now, possibly you might have pronounced it differently…network days, but it really has to do with work days.…So, no matter how you pronounce it, though,…it's a viable function, and we want to…calculate the number of working days…between these different projects here…where we've got a starting date and an ending date.…Now, a simple subtraction of the cells…does give us some time difference,…but that's all days, including weekends and holidays.…So, a simple subtraction here,…of later date minus the earlier date,…that gives us the value 126.…
I'm gonna move that off to the right,…just so we can remember it for a bit,…but how many working days are there?…Let's not count those weekend days,…the Saturdays and Sundays.…Equal NETWORKDAYS, as soon as we see that…in our list here click it, and we begin with…the starting date, comma and an ending date.…It does have an option for holidays.…I've got some of those listed over in column F…for the moment I will ignore them.…
Author
Dennis Taylor
Released
5/26/2016- Understanding how the hierarchy of operators affects formula results
- Knowing when to use absolute vs. relative references
- Using Formula Builder for unfamiliar functions
- Displaying a worksheet's formulas and highlighting formula cells
- Converting formulas to values
- Creating 3D formulas to gather data from multiple sheets
- Creating and expanding nested IF functions; using AND, OR, and NOT with IF
- Looking up information with VLOOKUP, HLOOKUP, MATCH, and INDEX
- Analyzing data with the statistical functions: MEDIAN, MODE, etc.
- Using the power functions: COUNTIF, SUMIF, COUNTIFS, AVERAGEIFS, and more
- Calculating financial data such as payments
- Performing basic math
- Calculating dates and times
- Editing text with functions
- Using array formulas and functions
- Referencing data in other cells and files
- Extracting information from Excel worksheets
Skill Level Intermediate
Duration
Views
-
Introduction
-
Welcome50s
-
Exercise files25s
-
-
1. Formula and Function Tools
-
2. Formula and Function Tips and Shortcuts
-
3. IF and Related Functions
-
4. Lookup and Reference Functions
-
Use MATCH and INDEX together4m 40s
-
5. Statistical Functions
-
6. Power Functions
-
7. Selected Financial Functions
-
8. Math Functions
-
9. Date and Time Functions
-
10. Text Functions
-
11. Array Formulas and Functions
-
12. Reference Functions
-
13. Information Functions
-
Conclusion
-
Next steps25s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Count working days with NETWORKDAYS