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
-
3:24
TECHNOLOGY, TIPS AND TRICK VIDEOS
9 months agoHow to Calculate Difference Between Two Dates in Excel
-
4:27
TECHNOLOGY, TIPS AND TRICK VIDEOS
9 months agoHow to Use the TODAY Function in Excel
8 -
5:51
WeTechCareOfYou
1 year agoSharePoint list Calculate a date from an existing date field for Working/Business days
6 -
0:54
NicetoLearn
1 year agoCalculate Working Hours in Excel
17 -
1:44
DansTechSolutions
1 year agoUseful Date Functions In Excel - Excel Tutorials
3 -
8:32
Computergaga
10 months agoWorking Days Between Two Dates in Power BI (NETWORKDAYS 🗓️)
5 -
4:56
Excelliott Technology
1 year agoExcel - Dynamic Date Function
1 -
12:24
Dexcelo
1 year agoCalculate dates difference in Excel | Excel Practice Case #17
7 -
11:58
WeTechCareOfYou
10 months ago $0.03 earnedPower Automate Calculate First Business Day of Month
46 -
1:25
DansTechSolutions
1 year agoHow To Workout The Difference Between Dates in Excel DATEDIF - Excel Tutorial