Jeffrey04

SELECT  COUNT(*) AS total_days
FROM    (SELECT DATE '2008-8-26' + generate_series(0, (DATE '2008-9-1' - DATE '2008-8-26')) AS all_days) AS calendar
WHERE   EXTRACT(isodow FROM all_days) < 6;
-- based on http://pastebin.com/m4c143e84