Hoo, Now I am understand,
You need to add last Saturday of Current month date fall in your Start date to end date exclude last Sunday and also other weekends.
If my understand is right means use below coding to resolve your issue and make sure this post as your solutions.
1+((DateDiff(DatePicker_Start.SelectedDate,DatePicker_End.SelectedDate,Days))*5-((Weekday(DatePicker_Start.SelectedDate)-Weekday(DatePicker_End.SelectedDate))*2))/7-Switch(Weekday(DatePicker_End.SelectedDate),7,1,0)-Switch(Weekday(DatePicker_Start.SelectedDate),1,1,0)
+
If((With({NextMonth:DateAdd(Date(Year(Now()),Month(Now()),1),1,Months)},DateAdd(NextMonth,-1*Weekday(DateAdd(NextMonth,-7))))>DatePicker_Start.SelectedDate-1)&&(With({NextMonth:DateAdd(Date(Year(Now()),Month(Now()),1),1,Months)},DateAdd(NextMonth,-1*Weekday(DateAdd(NextMonth,-7))))<DatePicker_End.SelectedDate+1),1,0)
before + Previous reply coding after + additional coding for your current needs. Above coding my side test and confirmed. Place above coding in your count text box
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways or you liked the post and want to show some appreciation, please give it a Thumbs Up.
