Nerwork days function

[#1]

Hi All,

I have start date and end date from which I want to calculate the number of days excluding week ends and holidays, but my week ends are not Saturday and Sunday, it is Thursday and Friday, hence I am not able to use network days function here. Can anyone help with alternative.

[Kushal_Chawda · Accepted solution]

I think this is quite similar to below

Networkdays function to change non working days from saturday-sunday to thursday-friday

[marcus_sommer]

Maybe this is helpful: NetWorkDays: Excluding Friday and Saturday between two dates

- Marcus

[buzzy996]

can u try this way,

define all ur holidays,like belwo..

Holidays:

LOAD * INLINE [

Holiday

01/01/2005

02/01/2005

08/01/2005

....etc

];

load

    concat(chr(39) & Holiday & chr(39),',') as list

Resident Holidays;

LET ListOfHolydays = Peek('list');

and use expression like this on ur chart?

Count(If(Networkdays(Column1,column2,$(ListOfHolydays))<'6',column3))

HTH