Skip to main content

SQL - Calculating Work Days

How many times have you wished that there was a parameter for DATEPART to allow you to check for workdays? While many of us may get stuck working 6 or 7 days a week, most of the world revolves on a 5 day work week, Monday through Friday.  Author Jeff Moden brings us a method of easily calculating the number of workdays between any two dates.  Although he wrote the original column in 2005, we like his idea so much; we are passing on his link for the Tidbit this week!  It does require a free registration to SQLSERVERCENTRAL, but we highly recommend the registration as a resource for you anyway!http://www.sqlservercentral.com/colu...ngworkdays.asp

 

  • Was this article helpful?