From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

NETWORKDAYS.INTL and WORKDAY.INTL

NETWORKDAYS.INTL and WORKDAY.INTL - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

NETWORKDAYS.INTL and WORKDAY.INTL

“

- [Instructor] If you're trying to determine 2 the length of a project in the past or in the future 3 in terms of number of days, 4 the two functions you want to be considering 5 are NETWORKDAYS and WORKDAY. 6 And each of them has a companion with the suffix INTL, 7 meaning international. 8 Let's first look at NETWORKDAYS. 9 If we were simply calculating the time left 10 between December 4th of 2017 and February 2nd of 2018, 11 we could simply subtract the two, 12 equal the later date minus the earlier date, it's 60 days. 13 But there were weekends there, let's not count them. 14 So let's use the function, NETWORKDAYS. 15 It's a long function. 16 As soon as you see it in the list, you can double click it. 17 Notice the two variations here. 18 I'll use the simple version first, 19 and first, click on start date comma end date, 20 and if we don't want to count those weekends automatically, 21 we just press enter 22…

Contents