Simple T-SQL to get the number of days between days excluding weekends.

BEGIN


DECLARE @end datetime
DECLARE @start datetime
SET@start='4/25/2012'
SET @end='5/02/2012'
SELECT DateDiff(dd, @start, @end) - DateDiff(ww, @start, @end)*2


END