In today’s video, I will show you how to calculate working days between two dates in Excel.
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 –
Paid Online Training –
Best Excel Books:
⚙️ Gear I Recommend:
Screen Recorder – techsmith.z6rjha.net/26D9Q
USB Mic –
Subscribe to get awesome Excel Tips every week:
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial