I know I'm being a pain 🙂
But is there a possibility to be able to:
I know it is hard to do. But can I do that? If it works, the code would be perfect. To be able to redefine the working hours whenever I want for future services, and define Holiday for Future services.
Thanks a million again.
This would really help me with my app to exclude Saturdays and Sundays. You obviously made this code to exclude Fridays and Saturdays. I've been messing with the code a bit to figure out how to exclude Sat and Sun but could not find out which values to tweak. Any chance you could modify the below code to accomodate for the exclusion of Saturdays and Sundays?
DateAdd(DataCardValueExitDate.SelectedDate, Value(Label5.Text) +
RoundDown(Value(Label5.Text) / 5, 0)*2+
Switch(Weekday(DataCardValueExitDate.SelectedDate),5,If(Mod( Value(Label5.Text) , 5)>0,2,0),
4,If(Mod( Value(Label5.Text) , 5)>1,2,0),
3,If(Mod( Value(Label5.Text) , 5)>2,2,0),
2,If(Mod( Value(Label5.Text) , 5)>3,2,0),
1,If(Mod( Value(Label5.Text) , 5)>4,2,0))
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand