NETWORKDAYS Function | Calculating Net Work Days in Power Query

Santosh asked about NETWORKDAYS and calculating net work days in Power Query. OUCH! This was rough.

NETWORKDAYS is a weird function. If you work at a restaurant that’s open 7 days/wk or a salon that’s closed on Mondays and Tuesdays, NETWORKDAYS makes a mess. However, using Power Query can be complicated with a lot of steps, but it’s more accurate than fiddling around with NETWORKDAYS.

This video has several phases:
0:00 Introduction
2:22 The NETWORKDAYS function
4:46 Calculating Net Work Days in Power Query
12:40 Outro

Download the file:
https://datascopic.net/wp-content/uploads/2021/06/NETWORKDAYS-PQ.xlsx
#NETWORKDAYS
#POWERQUERY
#Anti-Join
For a list of my Excel courses at Lynda/LinkedIn:
https://www.linkedin.com/learning/instructors/oz-du-soleil
There are courses on Power Query, Good spreadsheet habits, and a weekly Excel challenge that comes out every Friday.

Website: https://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition

My old blog: http://datascopic.net/blog-2-2