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
