NETWORKDAYS
Applies to: Calculated column Calculated table Measure Visual calculation
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.
NETWORKDAYS(<start_date>, <end_date>[, <weekend>, <holidays>])
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. |
An integer number of whole workdays.
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.
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.