Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Calc Networkdays from DD/MM/YYYY to DD/MM/YYYY

Hello everyone

I need help with find function to caculting duration from one event to another event

wich exclude international weekend    (SUNDAY,SATURDAY)

semilar to Ecel function :

NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])

the main purpode is to calclating

START  :DD/MM/YYYY        01/01/2018
END       DD/MM/YYYY        20/01/2018
  duration in nwtwrokdays

networksdays  15 Regualr days 19

Thanks

Aviad

2 Replies
Frank_Hartmann
Master II
Master II

Script:

Load *, Date#(Start,'DD/MM/YYYY') as Start1,

        Date#(End,'DD/MM/YYYY') as End1;

LOAD * INLINE [

    Start, End

    01/01/2018, 20/01/2018

];

Textbox Expression:

=NetWorkDays(Start1,End1)

Anonymous
Not applicable
Author

Thanks ,

I will try it .

Aviad