T SQL Script: Get Number of business days between two dates
T SQL Script: Get Number of business days between two dates
--Number of business days between two dates
CREATE FUNCTION dbo.BusinessDays (@Start DATE, @End DATE)
RETURNS INT
AS
BEGIN
DECLARE @Days INT = DATEDIFF(DAY, @Start, @End) + 1;
RETURN @Days
- (DATEDIFF(WEEK, @Start, @End) * 2)
- CASE WHEN DATENAME(WEEKDAY, @Start) = 'Sunday' THEN 1 ELSE 0 END
- CASE WHEN DATENAME(WEEKDAY, @End) = 'Saturday' THEN 1 ELSE 0 END;
END;