Premium Only Content

Excel NETWORKDAYS function: Calculate the number of working days between two dates
Jun 14, 2017 Excel Intermediate Functions & Features (For ALL Excel Versions)
Download the workbook here: http://www.xelplus.com/excel-workday-function/
Link to Workday function video: https://youtu.be/76BRqJHH4Mk
If you need to calculate the number of working days based on given start and end dates, you need to use the NETWORKDAYS function.
This is a great Excel formula for anyone planning deadlines and needs to find the number of working days available to them. This function excludes weekends as well. If you use NETWORKDAYS.INTL you can decide which days are considered weekends and should be excluded.
I also show you a way to make the selection for holidays dynamic. For example, if you are doing a project in one country and want to roll out that same project in other countries and you’d like the number of working days between the two dates to consider the holidays of the chosen country – the index function can come to the rescue.
★ My Online Excel Courses ► https://courses.xelplus.com/
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Camera: https://amzn.to/2FLiFho
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Microphone: https://amzn.to/2DVKstA
Lights: http://amzn.to/2eJKg1U
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel
-
1:43:11
Redacted News
3 hours agoBREAKING! TRUMP DECLARES WAR ON OBAMA "TREASON" AS A DEEP STATE RINGLEADER IN RUSSIA HOAX | REDACTED
120K116 -
1:22:13
Michael Franzese
4 hours agoPablo Escobar’s Son Breaks Silence About His Father, Narcos, and The Cartel
23.5K6 -
LIVE
SpartakusLIVE
1 hour agoThe $1,000 Spartakus Gauntlet || Huskerrs and Twitty
61 watching -
9:02
Hollywood Exposed
3 hours agoPiers Morgan's Guests ROAST DC's New Superman - It’s A Trainwreck!
4.08K3 -
LIVE
GSLouise
3 hours agoFIRST RUMBLE STREAM go easy on me
43 watching -
LIVE
Spartan
4 hours agoSpartan - Pro Halo Player for OMiT | Scrims vs Unreal Nightmare
18 watching -
17:23
Preston Stewart
4 hours ago $0.39 earnedSyria's Fragile Truce
5.76K1 -
1:00:00
BEK TV
21 hours agoOpen Range
3.12K -
57:24
CharLee Simons presents DO NOT TALK
20 hours agoSteve Hilton with CharLee Simons on DO NOT TALK
743 -
5:35:02
StoneMountain64
6 hours agoBattlefield 6 CONFIRMED + Delta Force Escaping PRISON with PROS
25.2K1