Please help!!! Outstanding Days Calculation excluding weekends and Bank holidays

[lennox25]

Hi, 

I have this calculated column  below, which almost does what I need. Currently it give me total days outstanding. I now need to exclude weekends and bank holidays can anyone help me with this please? I have network days - just need to know how to incorporate it into the calculation.

Days Outstanding =

IF(

    ISBLANK([EndDate])

    ,DATEDIFF([StartDate],TODAY(),DAY)

    ,BLANK()

)

[SamWiseOwl · Accepted solution]

Hi @lennox25 

There is a NetWorkdays function : https://learn.microsoft.com/en-us/dax/networkdays-function-dax

Days Outstanding =

IF(

    ISBLANK([EndDate])

    ,Networkdays([StartDate],TODAY(),1, Values(banktable[bankholidaydates]))

    ,BLANK()

)

[lennox25]

Perfect @SamWiseOwl you are awesome!