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

5 Comments

  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 […]

    • Wahab July 5, 2017 at 8:10 am - Reply

      Dear Ms. Leila,
      Is there any way to hide empty rows in excel printout, please recall “Lotus 123” if beginning of the row with “||” this one than that row will not print but it will be shown in worksheet.

      Thanks and Regards

      • Leila Gharani July 10, 2017 at 7:05 pm - Reply

        Hi Wahab,
        Unfortunately there is no short-hand for that. You could create a macro to hide empty rows before printing. As an alternative you could turn your data set into an Excel Table and filter out empty cells. You could also write an IF formula in the first cell that if the counta of the adjacent columns is empty it should put “to Hide” in the first cell and then filter out “to Hide” cells prior to printing….

  2. […] to the number of working days specified. (The link to how to use the WORKDAY() function is found here […]

  3. […] did that with the help of WORKDAY and NETWORKDAY […]

Leave A Comment

Share This