Leave Request form

[makhan1215]

Hello, I am working on leave request app but when i select leave start date and end date it does not exclude weekend from it. below are my FX. Please check

Onchange startdate and enddate picker:

RoundDown(DateDiff(StartDate.SelectedDate,EndDate.SelectedDate,Days)/7,0)*5+Mod(5+Weekday(EndDate.SelectedDate)-Weekday(StartDate.SelectedDate),5)

Label where total applied leave display when select start and end date. FX below.

FX on label Text:

DateDiff(Switch(Radio1.Selected.Value,"Half Day",DateAdd(StartDate.SelectedDate,12,Hours),StartDate.SelectedDate),Switch(Radio2.Selected.Value,"Day",DateAdd(EndDate.SelectedDate,24,Hours),EndDate.SelectedDate),Hours)/24

Please let me know how to exclude weekend from date selection