NetWorkingDay with Saturday Half Day

[MK_QSL]

Hi All,

We are working 5 and half day a week. (Saturday considered as a half day)

Can anyone provide script or expression to get NetWorkingDays?

Is there any other way to get the result without using NetWorkingDays?

Better if answer will be having an example...

Thanks

[Gysbert_Wassenaar]

Maybe this:

networkdays(startdate,enddate) + (div(enddate-startdate,7) - (weekday(startdate)>weekday(enddate))/2

[MK_QSL]

This expression giving error.

[MK_QSL]

Got the solution...

=NetWorkDays(vStartDate,vEndDate)+CEIL(SUM(((WEEKDAY(vStartDate-7)+vEndDate-vStartDate)/7)))/2