playlistduration

Excel Counting Workdays NETWORKDAYS WEEKDAY WORKDAY function

by excelisfun · 14 videos

Total watch time

1h 25m

at 1× speed · exactly 1 hour, 24 minutes, 51 seconds at 1×

1×1h 24m 51s
1.25×1h 7m 53s
1.5×56m 34s
1.75×48m 29s
2×42m 26s
Average video6m 4s
Longest11m 14s
Shortest1m 45s
Compare Open on YouTube JSON

Plan to finish

About 2 days at an hour a day

Pick a daily pace and the days you'll watch. Ticked videos are skipped.

Days

At one hour a day, every day, this playlist takes about 2 days. Turn on JavaScript to plan around your week.

Videos (14)

1h 25m in total · tick what you've watched

Tick videos you've watched — progress is saved in this browser.

Videos to
Watched
1 Excel Magic Trick 437: NETWORKDAYS Function for Counting Workdays 1:45 2009-11-02
2 Excel Magic Trick 438: Counting Workdays Without NETWORKDAYS Function (Weekend is not Sat. & Sun.) 10:01 2009-11-02
3 Excel Magic Trick 439: NETWORKDAYS.INTL function Excel 2010 2:11 2009-11-02
4 Excel Magic Trick 535: Count Weekdays Including Half Days NETWORKDAYS & NETWORKDAYS.INTL 5:57 2010-03-02
5 Excel Magic Trick 551: Count Mondays or Sundays or Tuesdays, etc. Between Start & End Date 7:34 2010-03-23
6 Excel Magic Trick #189: Count Days Not Sunday 5:34 2009-01-09
7 Excel Magic Trick 372: WORKDAY function - Find Date in Future 5:01 2009-08-27
8 Excel Magic Trick 554: Conditional Formatting for Weekends and Holidays Better than EMT 534 4:27 2010-03-23
9 Excel Magic Trick 327: Gantt Chart with Weekends and Holidays 8:16 2009-05-28
10 Mr Excel & excelisfun Trick 44: Count Mondays Between 2 Dates WEEKDAY or TEXT? 4:04 2010-02-26
11 Excel Magic Trick 564: Daily Gantt Chart 8:33 2010-04-05
12 Excel Magic Trick 563: WORKDAY.INTL & WORKDAY Excel 2010 Functions 2:22 2010-04-04
13 Excel Magic Trick 565: Excel 2010 Daily Gantt Chart 11:14 2010-04-05
14 Mr Excel excelisfun Trick 138: NETWORKDAYS.INTL Amazing New "Any Weekend" Argumnet 7:52 2013-09-09

Embed a badge

Show the watch time in a README or course description — it links back here and updates itself

Watch time: 1h 25m · 14 videos

Markdown
[![Watch time: 1h 25m · 14 videos](https://playlistduration.com/badge/playlist/PL6EC865028ED5F0C5.svg)](https://playlistduration.com/playlist/PL6EC865028ED5F0C5)
HTML
<a href="https://playlistduration.com/playlist/PL6EC865028ED5F0C5"><img src="https://playlistduration.com/badge/playlist/PL6EC865028ED5F0C5.svg" alt="Watch time: 1h 25m · 14 videos" width="203" height="20"></a>

Add ?speed=1.5 to the image URL for the time at that speed, ?label=Course to change the left text, or ?style=flat-square for square corners.

Want the numbers themselves? GET https://playlistduration.com/api/v1/playlist/PL6EC865028ED5F0C5 returns them as JSON — free, no key. API docs →

Data from the YouTube Data API as of 2026-09-22 (cached). Private or deleted videos are excluded from totals.