Dear all,
I have a question about networkdays and holidays.
I have a table with country code and dates of festivity.
I want to do a networkdays function between one start date and end date, but using as holidays date of destiny country, but i have no idea how to do that.
Example table
Sender;CountryS;Receiver;CountryR;StartDate;Enddate
1;ES;2;PT;02/01/2010;15/02/2010
1;ES;2;IT;02/01/2010;17/02/2010
Then I have another table with
FEST:
CountryR;Days
PT;04/01/2010
PT;07/01/2010
IT;05/01/2010
I want to do a networkdayes(StartDate,Endate;FEST DAYS THAT COUNTRY is COUNTRYR)
How can I do that function.
Best regards;
