Skip to content
  • There are no suggestions because the search field is empty.

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;