Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
Thanks ,
I will try it .
Aviad