When i Submit a leave request and go to start date click the next dat, my number of days was go to 6 days heres my code. Attached my screenshot
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
Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.
Check out the new Power Platform Community Connections gallery!