Yeah, plus the

(CASE WHEN TO_CHAR({trandate},'DY','nls_date_language=english')='SUN' THEN 1 ELSE 0 END)

etc to check if it starts / ends on a weekend