| Channel | Publish Date | Thumbnail & View Count | Actions |
|---|---|---|---|
 | Publish Date not found |  0 Views |
The following five examples are covered in this video:
— Calculating the total number of days between two dates
— Calculating working days (excluding weekend days and holidays)
— Calculating working days (when weekend days are not Saturday and Sunday)
— Calculating working days in a part-time job
— Calculating the number of Mondays in between two dates.
For calculating working days, Excel has two functions – NETWORKDAYS and NETWORKDAYS.INTL.
These formulas allow you to specify the weekend days as well as the holidays.
This video is a part of my ‘Excel is two-minute’ series, where I share simple and quick tips to help you speed up your work and be more efficient
Free Excel Course – https://trumpexcel.com/learn-excel/
Paid Online Training – https://trumpexcel.com/excel-training/
Best Excel Books: https://trumpexcel.com/best-excel-books/
️ Gear I Recommend:
Camera – https://amzn.to/3bmHko7
Screen Recorder – techsmith.z6rjha.net/26D9Q
USB Mic – https://amzn.to/2uzhVHd
Wireless Mic: https://amzn.to/3blQ8uk
Lighting – https://amzn.to/2uxOxRv
Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexcel?sub_confirmation=1
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
Please take the opportunity to connect and share this video with your friends and family if you find it useful.
