Forum Discussion

olimilo's avatar
olimilo
Icon for Post Prodigy rankPost Prodigy
9 years ago

NETWORKDAYS with Holidays from different countries

Hi guys, this is a bit of a challenge for me and I'm hoping someone can help lead me in the right direction.   I have a Records table that I need to check for the # of working days from StartDate t...
Need Help
olimilo's avatar
olimilo
Icon for Post Prodigy rankPost Prodigy
9 years ago

Hi Anonymous, I think that's only possible if the dates do not repeat. If 3 countries celebrate a holiday on 1/1/2017:

 

DateCountry
1/1/2017USA
1/1/2017China
1/1/2017Taiwan
1/1/2017Japan
1/1/2017Brazil
1/2/2017Brazil
......
12/31/2017USA
12/31/2017Brazil
12/31/2017Japan

 

This will make me unable to use the table since both columns have repeating values. I am unable to use a Holiday Flag column too since I'm working with holiday listings of more than 1 country.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

The date table will definately work because the Date Table is just every date possible.  There is only 1 occurance of any given date in this table.  Its something referred to as a Date Dimension Table.  The dates repeating in your existing tables is fine.