Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
In My table i have REQUEST_NO ,REQUEST_START_DATE AND REQUEST_END_DATE .
By using Interval match function i calculated the DURATION to complete the REQUEST.
but i want to exclude the Weekdays from DURATION. in my case Friday and Saturday are weekdays (holidays) . Sunday is the first day of my week.
I tried Networkdays() function but i didn't succeed to achieve the desired result.
Kindly find the attached sample file,
please help me to solve the my problem.
Thanks,
Mukram.
maybe with networkdays(REQUEST_START_DATE+1, REQUEST_END_DATE+1)
+1 to adapt your weekdays (friday and saturday) to "standard" (saturday and sunday) weekdays