topic Re: NETWORKS DAYS HELP (Exclude the Friday and Saturday. in QlikView

NETWORKS DAYS HELP (Exclude the Friday and Saturday.

Wed, 20 Mar 2013 11:31:06 GMT

Hi,

If a source containing: - Dates are in DD-MM-YYYY format.

StartDate, EndDate

01-03-2013, 31-03-2013

In this case the exclude the days are Friday and Saturday, How can I excludes these are days in the Networkdays function.

Regatds - Amit Kumar

Re: NETWORKS DAYS HELP (Exclude the Friday and Saturday.

Gysbert_Wassenaar — Wed, 20 Mar 2013 11:42:31 GMT

Try networkdays(StartDate+1,EndDate+1)

Re: NETWORKS DAYS HELP (Exclude the Friday and Saturday.

Wed, 20 Mar 2013 12:14:08 GMT

Hi Gysbert,

For details, Please go through the following and revert me:

I have 2 fields - Vessel Depart, Final BL and BL Days. First of all I have to exclude Friday and Saturday from Vessel Depart and Final BL.

BL Days Calculation is : Max([Final BL])-Max([Vessel Depart])

But this BL Days Calculation is included Friday and Saturday.

Please find the attached xls for help.

Thanks for Reply and Help.