Hi all,
I'm having some problems while I try to get flexible holidays using NETWORKDAYS.INTL() function.
What I want to do is to get a vector of holidays and insert it in this function, but I'm getting an error.
What I do is the following:
=IFERROR(NETWORKDAYS.INTL(AA2;AD2;1;VLOOKUP(INT(LEFT([@[Postal Code]];LEN([@[Postal Code]])-3));Table1[#All];3;FALSE))-1;"")
Table 1:
Capture.JPG
I guess it may be because of the formats.
Thank you very much.
Kind regards.
Bookmarks