Net Work Days
Recreates the NETWORKDAYS function from Excel with some bonus measures and one that needs fixed or demonstrates a bug/documentation glitch.
NetWorkDays calculates the number of days between two...
This is a great solution.
just wondering if it is possible to pull this detail from a separate table where we can enter public holidays by year?
VAR Holidays1 = DATATABLE("Date",DATETIME,
{
{"12/25/2017 12:00:00 AM"}
})
for e.g. a table will hold Public holidays like this:
|
Holidays date |
| 01/01/2020 |
| 25/12/2020 |
| 01/01/2021 |
| 25/12/2021 |
| 26/12/2021 |
Anonymous Greg_Deckler Any luck on how to you use a list of holiday list please...