How many business day is between 2 dates ? like between June 4th 2009 and
In SQL Server, the number of days between 2 days can be calculated using datediff() function
SELECT days = DATEDIFF(DAY, '2009-06-04', '2009-06-09')
But this will give you 5 days.
The business days between
So how to calculate the number of business days between 2 dates ?
I will go though various methods in my coming posts
Area to cover will be
- Calculate Business Day – With Calendar Table
- Calculate Business Day – Without Calendar Table
- Calculate Business Day – With a function