DateTime Difference excluding weekends/holidays

[Anonymous]

Hi,

How do I calculate the difference between two datetime columns and exclude weekends/holidays from the calculation?

I have created a standard calendar table and a public holidays table but not sure how to marry them together. 

Appreciate any help. 

[AlB]

Hi @Anonymous 

Probably best is to merge both tables. Just add a new column to the main calendar table specifying whether a day is a holiday and another columns  whether it's weekday or weekend. Then you can just calculate the date difference by count the number of days in between your two dates excluding holidays and weekends.

Please mark the question solved when done and consider giving kudos if posts are helpful.

Cheers  

[Anonymous]

@AlB that makes sense and makes it easier to manage. Will try that. Thank you.