Excel’s workday function is great when you need to calculate an end date based on a given number of working days – which means you need to exclude weekends and holidays. Some examples are:
creating a project timeline
creating a reporting timetable
Excel’s standard WORKDAY formula assumes weekends fall on Saturdays and Sundays. In case the weekends in your country fall on other days, you will need to use Workday.intl where you have an additional option to select the weekend days.
Watch the video to find out how to use the WORKDAY function:
On the other hand, 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 function 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.
In the video below 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.
Watch the video to find out how to use the NETWORKDAYS function:
- WORKDAY does not count start day
- NETWORKDAYS does count start day
Feel free to Download the Workbook HERE.
The new Excel Dashboards course is here!
Now available on Udemy
Visually Effective Excel Dashboards for your reports.
Redeem your coupon for 75% off below.