Type
Date
Calculate business days within a date range
lets(
startDate, prop("Date").dateStart(),
endDate, prop("Date").dateEnd(),
startOffset, startDate.day() % 7,
endOffset, endDate.day() % 7,
daysBetween, endDate.dateBetween(startDate, "days") + 1 + startOffset - endOffset,
startSubtract, startOffset == 0 ? 1 : startOffset,
endSubtract, endOffset == 6 ? 5 : endOffset,
(daysBetween - (daysBetween / 7 * 2) - startSubtract + endSubtract).round()
)
Output:
Note: The calculation does not exclude public holidays.