Count work days between two dates?

Question

How can I calculate the number of work days between two dates in SQL Server? Monday to Friday and it must be T-SQL.

Answer 1

Try using the DATEDIFF function!

You can fine more here: https://docs.microsoft.com/en-us/sql/t-sql/functions/datediff-transact-sql?view=sql-server-ver15