networkdays() and holidays

[lastnn30]

Hi

Can I have holidays as a column in the same main table which has the start and end dates? I tried in the same table but did not work. I had to put the holidays in different table and to my surprise, I did not have to create relationship. How you would have done it yourself? Thank you very much.

[Ashish_Mathur · Accepted solution]

Hi,

No.  There is no way of doing it in the same table.  Yours is the correct approach.