SELECT IF( DAYOFWEEK( date_from ) >=2
AND DAYOFWEEK( date_from ) <=6, IF( DATEDIFF( date_to, date_from ) , 2, 1 ) , 1 ) AS n
FROM (

SELECT '2007-05-02' AS date_from, '2007-12-02' AS date_to
) AS init