NETWORKDAYS: Calculate working days

…If you're trying to calculate the length of a project, imagine…a situation where we've got a starting date, and an ending date.…You want to know how long the project is.…A simple subtraction of the two dates might get us started…but this is going to count all days including Saturdays and Sundays.…So, a simple subtraction here does give us the difference between the two dates.…That's a 99 day time frame there.…Notice that column A has some holidays in it.…In calculating the actual working days, we certainly do…not want to count the weekends and ultimately the holidays.…

So, let's approach this a little bit differently…with a function called network days equal N.…And since it is a long function name, as soon as you see it click it.…By the way, notice that there's a variation on it which you'll see.…Network days.intl, meaning international.…But we want to use network days right here, we can tab it into place.…This begins with the starting date, that's in cell E2, comma, and…ending date, that's in E3, and for the moment let's ignore the holidays.…