Edit

NETWORKDAYS

  • Article

Returns the number of whole workdays between two dates (inclusive). Parameters specify which and how many days are weekend days. Weekend days and days specified as holidays are not considered as workdays.

Syntax

NETWORKDAYS(<start_date>, <end_date>[, <weekend>, <holidays>])

Parameters

Term Definition
start_date A date that represents the start date. The dates for which the difference is to be computed. The start_date can be earlier than, the same as, or later than the end_date.
end_date A date that represents the end date. The dates for which the difference is to be computed. The start_date can be earlier than, the same as, or later than the end_date.
weekend Indicates the days of the week that are weekend days and are not included in the number of whole working days between start_date and end_date. Weekend is a weekend number that specifies when weekends occur.
Weekend number values indicate the following weekend days:
1 or omitted: 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
holidays A column table of one or more dates that are to be excluded from the working day calendar.

Return Value

An integer number of whole workdays.

Remarks

  • This DAX function is similar to Excel NETWORKDAYS.INTL and NETWORKDAYS functions.

  • If start_date and end_date both are BLANK, the output value is also BLANK.

  • If either start_date or end_date is BLANK, the BLANK start_date or end_date will be treated as Date(1899, 12, 30).

  • Dates must be specified by using DATE function or as the result of another expression. For example, DATE ( 2022, 5, 30 ), specifies May 30th, 2022. Dates can also be specified as a literal in format, (dt”2022-05-30”). Do not specify dates as text.

Example

The following expression:

   = NETWORKDAYS (
        DATE ( 2022, 5, 28 ),
        DATE ( 2022, 5, 30 ),
        1,
        {
            DATE ( 2022, 5, 30 )
        }
    )

Returns:

[Value]
0

In this example, 0 is returned because the start date is a Saturday and the end date is a Monday. The weekend parameter specifies that the weekend is Saturday and Sunday, so those are not work days. The holiday parameter marks the 30th (the end date) as a holiday, so no working days remain.