Can someone help me to amend formula to calculate half day in leave request.
The formula I'm currently using is below:
With(
{
// generate a one-column table of all dates between start date & end date
varDateRange: ForAll(
Sequence(dte_EndDate.SelectedDate - dte_StartDate.SelectedDate + 1),
dte_StartDate.SelectedDate + Value - 1
)
},
If(
And(
IsBlank(dte_StartDate.SelectedDate),
IsBlank(dte_EndDate.SelectedDate)
),
// show nothing if any date pickers are blank
0,
// show only dates Monday to Friday and exclude holidays
CountIf(
varDateRange,
And(
Weekday(Value) in [2, 3, 4, 5, 6],
Not(Value in Holidays.HolidayDate)
)
)
)
)
