From the course: Excel 2016: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 22,500 courses taught by industry experts or purchase this course individually.

Counting working days with the NETWORKDAYS function

Counting working days with the NETWORKDAYS function

From the course: Excel 2016: Advanced Formulas and Functions

Start my 1-month free trial

Counting working days with the NETWORKDAYS function

“

- In this worksheet called NETWORKDAYS, we're tracking projects, starting dates, ending dates, and a project length with a simple formula here that really subtracts the two dates. And this is just fine if this is a seven day a week project, but many times that's not the case. We only want to count weekdays. We'll show initially how this would work for any country where the weekdays are Monday through Friday. Instead of this number here, which counts all days, let's use a function called NETWORKDAYS. This is a long function name, so as you start to type this, n, right away you're probably seeing NETWORKDAYS, right here. Click this, tab it into place. Notice below this another function, which we'll see in a moment, NETWORKDAYS.INTL, meaning international. So, we'll tab this into place, and we have a starting date, that's in cell B2, comma an ending date, right here. So, how many days has this project taken? If it's in the past, or it overlaps the future, makes no difference. We'll…

Contents