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
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.