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
-
DVR
The Big Mig™
2 hours agoVindicated, Ven Miller Live Interview
12.1K3 -
LIVE
Film Threat
7 hours agoVERSUS: ART THE CLOWN VS JOKER! TERRIFIER 3 RULES! AND THE BEST HORROR FILMS | Film Threat Versus
323 watching -
LIVE
Revenge of the Cis
3 hours agoEpisode 1390: Happy Columbus Day
2,873 watching -
1:59:58
Barstool Yak
5 hours agoThe Yak with Big Cat & Co. Presented by Rhoback | The Yak 10-14-24
14.8K1 -
1:45:51
The Quartering
4 hours agoTrump Assassin Setup, Joe Rogan & Trump To Collab & Kamala Harris Is Falling Apart!
46.4K29 -
23:07
ROSE UNPLUGGED
21 hours agoThe Catastrophe of Our Modern Culture
7.65K2 -
1:22:20
vivafrei
6 hours agoUNDERWHELMING Evidence of Tim Walz "Sex Scandal"! Another Trump Plot? Canada Update with MY BRO!
74.8K76 -
27:05
-
1:21:16
Game On!
5 hours agoNFL and CFB Favorites Strike Back! | Crick's Corner
25.6K -
1:10:06
The Kevin Trudeau Show
7 hours agoInsider Spy Agency Secrets Revealed | The Kevin Trudeau Show | Ep. 56
23.4K6