How can I calculate the number of work days between two dates in SQL Server?

Monday to Friday and it must be T-SQL.

Skip to content
# Sql – Count work days between two dates

###### Related Topic

datesqltsql

How can I calculate the number of work days between two dates in SQL Server?

Monday to Friday and it must be T-SQL.

- Sql-server – How to check if a column exists in a SQL Server table
- Python – How to calculate number of days between two given dates
- Javascript – How to get a timestamp in JavaScript
- Javascript – Compare two dates with JavaScript
- Javascript – How to get the number of days between two dates in JavaScript
- C# – Calculate difference between two dates (number of days)
- Sql – How to UPDATE from a SELECT in SQL Server
- Java – Why is subtracting these two times (in 1927) giving a strange result

## Best Answer

For workdays, Monday to Friday, you can do it with a single SELECT, like this:

If you want to include holidays, you have to work it out a bit...