DataWeave - Range of Dates (Array) filtering Holidays, Saturday and Sunday.

fun_rangeDate_filter_holidays_and_weekend.dwl

%dw 2.0
output application/json

fun isWeekend(d: String | Date) = do {
    ["1","7"] contains ((d as Date) as String { format: "c"})
}

fun isWeekday(d: String | Date) = do {
    not (["1","7"] contains ((d as Date) as String { format: "c"}))
}

var startDate = |2023-11-01|
var endDate = |2023-11-30|

// Array of String converted to Date
var holidays = ["2023-11-02", "2023-11-15"] map $ as Date

// Array of Date from startDate until endDate
var dateRange = (0 to daysBetween(startDate, endDate)) as Array map( startDate + ("P$($$)D" as Period) )
---
dateRange filter ( 
    // Get position of Date inside holidays Array, it will return -1 when do not exist
    (holidays indexOf $ ) == -1
    
    and

    // 
    ( isWeekday($) )
)