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:18:49
Kim Iversen
6 hours agoEXPOSED: Inside Tim Pool’s Secret Meeting with Netanyahu | Trump’s Tariff Gamble: Boost for America or Death Blow?
119K191 -
5:28:29
Biscotti-B23
6 hours ago $0.69 earned🔴 LIVE GETSUGA GAUNTLET 🔥 TRAINING FOR RANKED ⚔ BLEACH REBIRTH OF SOULS
16.7K -
1:19:00
Sarah Westall
3 hours agoMassive Spiral Structures Found Under Giza Pyramids, Advanced Ancient Societies w/ Jay Anderson
38.5K13 -
54:32
LFA TV
10 hours agoStrongman Stare Down | TRUMPET DAILY 4.9.25 7PM
45.4K7 -
1:35:31
Redacted News
6 hours agoBioweapons over America? U.S. Geo-engineering caught raining mysterious objects over U.S. | Redacted
180K238 -
1:19:20
vivafrei
8 hours agoCanadian Government & Courts Denying Military Jab Injury Compensation? Trump Pronouns "No Thanks"?
116K36 -
54:20
Candace Show Podcast
6 hours agoHarvey Weinstein Calls Out Justin Baldoni | #MAHA Gaslighting Begins | Candace Ep 174
114K109 -
22:26
Exploring With Nug
9 hours ago $1.17 earnedI Found a Heavy Bag Underwater Scuba Diving! What's Inside?
25.3K1 -
LIVE
Dr Disrespect
10 hours ago🔴LIVE - DR DISRESPECT - WARZONE VERDANSK - THE NUKE
1,538 watching -
2:52:47
Canada Strong and Free Network
4 hours agoCanada Strong and Free Network
35.7K3