SQL Working Days between 2 dates


I would like to know how to calculate the total working days between 2 dates in an sql statement, to implement in an advanced query.

Thank you.

Hi Alexandre,


I haven't tested this myself but you might want to take a look into this page: Count work days between two dates in T-SQL.



Tiago Simões 

Hi Tiago,

Thank you very much, it works just great.