Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Maybe this:
networkdays(startdate,enddate) + (div(enddate-startdate,7) - (weekday(startdate)>weekday(enddate))/2
This expression giving error.
Got the solution...
=NetWorkDays(vStartDate,vEndDate)+CEIL(SUM(((WEEKDAY(vStartDate-7)+vEndDate-vStartDate)/7)))/2