Excel WORKDAY & NETWORKDAYS Functions: Exclude Weekends and Holidays

excel dashboards reportsExcel’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:

Watch out:

  • WORKDAY does not count start day
  • NETWORKDAYS does count start day

Feel free to Download the Workbook HERE.

Free Excel Download

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.

GET 75% OFF THE COURSE
Free Ebook

One Comment

  1. Quick Gantt Chart | June 18, 2017 at 9:17 am - Reply

    […] let’s say, you just setup a preliminary project plan in Excel. You did that with the help of WORDAY and NETWORKDAY […]

Leave A Comment

Share This