Calculating the Number of Work Days between two dates for unusual shifts

  • Excel
  • 2016
When calculating the difference between two dates, you may want to exclude weekends and holidays. You can see how to calculate the number of Working Days between two dates for the usual, standard working week where weekends are Saturdays and Sundays.

If you have unusual working week such as weekends on Sundays and Mondays, you can use other formula in Excel.

For example, you may need to know how many business days fall into November 2018. This calculation should exclude Sundays, Mondays and holidays.

The NETWORKDAYS.INTL function calculates the difference between two dates, excluding weekend days (see the table below):

Number of Work Days for unusual shifts in Excel 2016

As an option, you can specify a range of cells that contain the dates of holidays, which are also excluded. Excel has absolutely no way of determining which days are holidays, so you must provide this information in a separate range.

Work Days for unusual shifts in Excel 2016
Weekend number Weekend days
1 (default) Saturday, Sunday
2 Sunday, Monday
3 Monday, Tuesday
4 Tuesday, Wednesday
5 Wednesday, Thursday
6 Thursday, Friday
7 Friday, Saturday
11 Sunday only
12 Monday only
13 Tuesday only
14 Wednesday only
15 Thursday only
16 Friday only
17 Saturday only

Note: Unfortunately, this formula doesn’t work for four-day workweeks or for shifts. See How to calculate the number of work days for a four-day workweek.

Ask a Question

We use your email only for the communication between you and our team.

Your email Please enter your email Your email

If you have any questions or suggestions, please feel free to ask OfficeToolTips team.

Thank you for visiting OfficeToolTips

We are glad to help you in your work. However, you are using ad blocker and our efforts will not be rewarded.

Please consider disabling ad blocker before continuing the reading.