Networkdays function

To use this function, choose Calc > Calculator.

Returns the number of workdays (M-F) between two dates, inclusive. This Minitab Calculator function is useful for determining how many workdays have elapsed, with a specified start date and end date. For example, as part of a quality improvement project, you want to track the number of working days it takes to finish a product order. You record the date each order was received and the date the product was finished.

Syntax

NETWORKDAYS(start date,end date,[holidays])

For start date and end date, you can enter a column of dates or a single date in double quotation marks. If the dates include time portions, Minitab ignores the times. You can also specify a column of holidays (or a date in double quotation marks) for the optional third argument ([holidays]). Minitab will not count the holidays when it tallies the number of net workdays.

Note

When you enter single dates, you also need to use the DATE function. For example, to find out the number of workdays between 1/1/09 and 1/31/09, enter NETWORKDAYS (DATE("1/1/09"), DATE("1/31/09")).

Example

A manager wants to track the time it takes to finish a product. He enters the dates when orders are received and when they are completed, plus a column of holidays when no work was done. To determine the workdays it took to finish the orders, the manager enters the expression NETWORKDAYS(C1,C2,C3) and stores the results in C4.

C1-D C2-D C3-D C4
Order received Product completed Holidays Total workdays
5/12/2014 5/24/2014 5/26/2014 10
5/15/2014 5/22/2014 7/4/2014 6
5/15/2014 5/30/2014   11
5/18/2014 6/14/2014   19
5/18/2014 6/5/2014   14
5/18/2014 6/28/2014   29
5/19/2014 6/20/2014   24
5/20/2014 7/3/2014   32