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
-
LIVE
Matt Kohrs
10 hours ago🔴[LIVE] STOCKS FALL: Inflation Report, GDP Data & Live Trading || The MK Show
5,033 watching -
LIVE
NEWSMAX
1 hour agoThe Gerry Callahan Show LIVE (04/30/2025) | NEWSMAX Podcasts
429 watching -
59:38
BEK TV
11 hours agoMedical Mysteries Revealed. What Mel Gibson and Joe Rogan were Afraid to Say
2.43K -
LIVE
LFA TV
13 hours agoALL DAY LIVE STREAM - WEDNESDAY 4/30/25
5,398 watching -
1:43:51
Chicks On The Right
4 hours agoTrump's contentious ABC interview, Trump's truths and trolls, and is AOC gonna run for president?
23.7K7 -
25:15
Producer Michael
18 hours agoTOURING A $10,800,000 LAS VEGAS MODERN MANSION!
45.6K9 -
1:57:01
BEK TV
1 day agoTrent Loos in the Morning 4/30/2025
41.7K1 -
15:35
The Illusion of Consensus
1 day agoRav Arora Warns Danger of Mass Immigration In Canada
37.1K13 -
26:33
CatfishedOnline
1 day agoI Sent $150k And Sold My Home For Online Love!
75.3K18 -
7:37
The Shannon Joy Show
15 hours ago💀 Doctor Death: NY’s Suicide Bill
54.3K14