NETWORKDAYS and NETWORKDAYS.INTL functions in Excel
In this video, we will be looking at two of the most versatile functions in Excel. NETWORKDAYS.INTL and WORKDAY.INTL. They are an upgrade to the NETWORKDAYS and WORKDAY functions, and they take them to a new level. It's like MAX and LARGE or MIN and SMALL or ROUND and MROUND or ROUNDUP and CEILING... This INTL versions of NETWORKDAYS and WORKDAY functions enable you to define your own "weekends" or, even better, your workweek days. If you are looking for the number of workdays that passed between two dates, if you only worked every Monday, Wednesday, and Friday. Just brilliant.
This tutorial was made using Excel 365, but all methods work with Excel 2010 and above.
File if you want to follow along:https://bit.ly/34npiTs
Links to other videos and blog posts that are relevant:
WORKDAY.INTL and NETWORKDAYS.INTL: https://bit.ly/3odgc2M
Chapters:
0:00 Excel Olympics Animation
0:08 Introduction to the WORKDAY and NETWORKDAYS functions
1:34 WORKDAY function in Excel
3:45 NETWORKDAYS function in Excel
4:53 The need for something more
6:02 WORKDAY.INTL function in Excel
8:02 NETWORKDAYS.INTL function in Excel
8:40 Extra useful functions
9:51 Conclusion
10:22 Outro
Gear Used:
US Links
Camera: Canon EOS R6 - https://amzn.to/3e9zxML
Microphone: AKG C3000 (Analog Mic) - https://amzn.to/3tYd37w
Audio converter: Zoom UAC-2 - https://amzn.to/3dgM8wS
Laptop: Dell XPS 15 - https://amzn.to/3w8CyoK
Lights: Elgato Key Light - https://amzn.to/3rurte7
EU Links
Camera: Canon EOS R6 - https://amzn.to/3tubwGy
Microphone: AKG C3000 (Analog Mic) - https://amzn.to/32pi2m0
Audio converter: Zoom UAC-2 - https://amzn.to/3amDRXP
Laptop: Dell XPS 15 - https://amzn.to/3effMmT
Lights: Elgato Key Light - https://amzn.to/3vcs6v9
Green Screen (visible in bloopers): https://amzn.to/3ajUm6Y
Recorded With: Camtasia - https://www.techsmith.com/video-edito...
Subscribe for more Excel tutorials on the Excel Olympics YouTube Channel: http://bit.ly/EOYTsub
Subscribe for the Excel Olympics Newsletter: https://bit.ly/3w3rkjK
Disclaimer: Some links included in this description might be affiliate links. If you purchase a product or service with the links that I provide, I may receive a small commission with NO additional charge to you! I appreciate your support!
#Excel #ExcelOlympics #gasperkamensek