Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
i'm using this formula NetWorkDays(Date,Date) as WorkingDay to calculate working days; based on this all days from Monday to Friday are considered as working.
I would like to add an excel file, where to list only the holidays and have then the flag WorkingDay to 0 (which means non-working-day).
Anyone can help me and suggest me how to achieve this?
Thank you
Hi Antonio,
File Excel like this below
Script :
LOAD Concat(DISTINCT Chr(39)&Holiday&Chr(39),',') as HDS;
LOAD Date(Holiday) as Holiday
FROM
[Holiday.xls]
(biff, embedded labels, table is Foglio1$);
LET vHolidays=Peek('HDS');
Expression :
=NetWorkDays('01/07/2017','31/07/2017',$(vHolidays))
Regards,
Antonio