Power Platform Community Forum Thread Details

I have a leave request, my Startdate and endDate was excluded sunday and holidays. But I want to include weekends and Holidays to a particular leave type. For example when i select Maternity Leave weekends and holidays should be included but when i selectect Vacation leave Sunday and holidays should be excluded. Thank you

Here's my code on number of days

RoundDown(
DateDiff(
StartDates.SelectedDate,
EndDates.SelectedDate,
Days
) / 7,
0
) * 6 + Mod(
6 + Weekday(EndDates.SelectedDate) - Weekday(StartDates.SelectedDate),
6

) + If(Checkbox3.Value = false , 0.5)

- CountRows(
Filter(
colHolidays,
HolidayDates >= StartDates.SelectedDate,
HolidayDates <= EndDates.SelectedDate
)
)+1 /2

Categories:

Building Power Apps