NETWORKS DAYS HELP (Exclude the Friday and Saturday.

[#1]

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

[Gysbert_Wassenaar]

Try networkdays(StartDate+1,EndDate+1)

[#3]

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.